package com.anolesoft.yr.mbus.cont.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class ContMainExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ContMainExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andObjuidIsNull() {
            addCriterion("objuid is null");
            return (Criteria) this;
        }

        public Criteria andObjuidIsNotNull() {
            addCriterion("objuid is not null");
            return (Criteria) this;
        }

        public Criteria andObjuidEqualTo(String value) {
            addCriterion("objuid =", value, "objuid");
            return (Criteria) this;
        }

        public Criteria andObjuidNotEqualTo(String value) {
            addCriterion("objuid <>", value, "objuid");
            return (Criteria) this;
        }

        public Criteria andObjuidGreaterThan(String value) {
            addCriterion("objuid >", value, "objuid");
            return (Criteria) this;
        }

        public Criteria andObjuidGreaterThanOrEqualTo(String value) {
            addCriterion("objuid >=", value, "objuid");
            return (Criteria) this;
        }

        public Criteria andObjuidLessThan(String value) {
            addCriterion("objuid <", value, "objuid");
            return (Criteria) this;
        }

        public Criteria andObjuidLessThanOrEqualTo(String value) {
            addCriterion("objuid <=", value, "objuid");
            return (Criteria) this;
        }

        public Criteria andObjuidLike(String value) {
            addCriterion("objuid like", value, "objuid");
            return (Criteria) this;
        }

        public Criteria andObjuidNotLike(String value) {
            addCriterion("objuid not like", value, "objuid");
            return (Criteria) this;
        }

        public Criteria andObjuidIn(List<String> values) {
            addCriterion("objuid in", values, "objuid");
            return (Criteria) this;
        }

        public Criteria andObjuidNotIn(List<String> values) {
            addCriterion("objuid not in", values, "objuid");
            return (Criteria) this;
        }

        public Criteria andObjuidBetween(String value1, String value2) {
            addCriterion("objuid between", value1, value2, "objuid");
            return (Criteria) this;
        }

        public Criteria andObjuidNotBetween(String value1, String value2) {
            addCriterion("objuid not between", value1, value2, "objuid");
            return (Criteria) this;
        }

        public Criteria andContTypeUidIsNull() {
            addCriterion("cont_type_uid is null");
            return (Criteria) this;
        }

        public Criteria andContTypeUidIsNotNull() {
            addCriterion("cont_type_uid is not null");
            return (Criteria) this;
        }

        public Criteria andContTypeUidEqualTo(Byte value) {
            addCriterion("cont_type_uid =", value, "contTypeUid");
            return (Criteria) this;
        }

        public Criteria andContTypeUidNotEqualTo(Byte value) {
            addCriterion("cont_type_uid <>", value, "contTypeUid");
            return (Criteria) this;
        }

        public Criteria andContTypeUidGreaterThan(Byte value) {
            addCriterion("cont_type_uid >", value, "contTypeUid");
            return (Criteria) this;
        }

        public Criteria andContTypeUidGreaterThanOrEqualTo(Byte value) {
            addCriterion("cont_type_uid >=", value, "contTypeUid");
            return (Criteria) this;
        }

        public Criteria andContTypeUidLessThan(Byte value) {
            addCriterion("cont_type_uid <", value, "contTypeUid");
            return (Criteria) this;
        }

        public Criteria andContTypeUidLessThanOrEqualTo(Byte value) {
            addCriterion("cont_type_uid <=", value, "contTypeUid");
            return (Criteria) this;
        }

        public Criteria andContTypeUidIn(List<Byte> values) {
            addCriterion("cont_type_uid in", values, "contTypeUid");
            return (Criteria) this;
        }

        public Criteria andContTypeUidNotIn(List<Byte> values) {
            addCriterion("cont_type_uid not in", values, "contTypeUid");
            return (Criteria) this;
        }

        public Criteria andContTypeUidBetween(Byte value1, Byte value2) {
            addCriterion("cont_type_uid between", value1, value2, "contTypeUid");
            return (Criteria) this;
        }

        public Criteria andContTypeUidNotBetween(Byte value1, Byte value2) {
            addCriterion("cont_type_uid not between", value1, value2, "contTypeUid");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidIsNull() {
            addCriterion("cont_template_uid is null");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidIsNotNull() {
            addCriterion("cont_template_uid is not null");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidEqualTo(String value) {
            addCriterion("cont_template_uid =", value, "contTemplateUid");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidNotEqualTo(String value) {
            addCriterion("cont_template_uid <>", value, "contTemplateUid");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidGreaterThan(String value) {
            addCriterion("cont_template_uid >", value, "contTemplateUid");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidGreaterThanOrEqualTo(String value) {
            addCriterion("cont_template_uid >=", value, "contTemplateUid");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidLessThan(String value) {
            addCriterion("cont_template_uid <", value, "contTemplateUid");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidLessThanOrEqualTo(String value) {
            addCriterion("cont_template_uid <=", value, "contTemplateUid");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidLike(String value) {
            addCriterion("cont_template_uid like", value, "contTemplateUid");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidNotLike(String value) {
            addCriterion("cont_template_uid not like", value, "contTemplateUid");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidIn(List<String> values) {
            addCriterion("cont_template_uid in", values, "contTemplateUid");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidNotIn(List<String> values) {
            addCriterion("cont_template_uid not in", values, "contTemplateUid");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidBetween(String value1, String value2) {
            addCriterion("cont_template_uid between", value1, value2, "contTemplateUid");
            return (Criteria) this;
        }

        public Criteria andContTemplateUidNotBetween(String value1, String value2) {
            addCriterion("cont_template_uid not between", value1, value2, "contTemplateUid");
            return (Criteria) this;
        }

        public Criteria andIsTempIsNull() {
            addCriterion("is_temp is null");
            return (Criteria) this;
        }

        public Criteria andIsTempIsNotNull() {
            addCriterion("is_temp is not null");
            return (Criteria) this;
        }

        public Criteria andIsTempEqualTo(Byte value) {
            addCriterion("is_temp =", value, "isTemp");
            return (Criteria) this;
        }

        public Criteria andIsTempNotEqualTo(Byte value) {
            addCriterion("is_temp <>", value, "isTemp");
            return (Criteria) this;
        }

        public Criteria andIsTempGreaterThan(Byte value) {
            addCriterion("is_temp >", value, "isTemp");
            return (Criteria) this;
        }

        public Criteria andIsTempGreaterThanOrEqualTo(Byte value) {
            addCriterion("is_temp >=", value, "isTemp");
            return (Criteria) this;
        }

        public Criteria andIsTempLessThan(Byte value) {
            addCriterion("is_temp <", value, "isTemp");
            return (Criteria) this;
        }

        public Criteria andIsTempLessThanOrEqualTo(Byte value) {
            addCriterion("is_temp <=", value, "isTemp");
            return (Criteria) this;
        }

        public Criteria andIsTempIn(List<Byte> values) {
            addCriterion("is_temp in", values, "isTemp");
            return (Criteria) this;
        }

        public Criteria andIsTempNotIn(List<Byte> values) {
            addCriterion("is_temp not in", values, "isTemp");
            return (Criteria) this;
        }

        public Criteria andIsTempBetween(Byte value1, Byte value2) {
            addCriterion("is_temp between", value1, value2, "isTemp");
            return (Criteria) this;
        }

        public Criteria andIsTempNotBetween(Byte value1, Byte value2) {
            addCriterion("is_temp not between", value1, value2, "isTemp");
            return (Criteria) this;
        }

        public Criteria andSignDateIsNull() {
            addCriterion("sign_date is null");
            return (Criteria) this;
        }

        public Criteria andSignDateIsNotNull() {
            addCriterion("sign_date is not null");
            return (Criteria) this;
        }

        public Criteria andSignDateEqualTo(Date value) {
            addCriterionForJDBCDate("sign_date =", value, "signDate");
            return (Criteria) this;
        }

        public Criteria andSignDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("sign_date <>", value, "signDate");
            return (Criteria) this;
        }

        public Criteria andSignDateGreaterThan(Date value) {
            addCriterionForJDBCDate("sign_date >", value, "signDate");
            return (Criteria) this;
        }

        public Criteria andSignDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("sign_date >=", value, "signDate");
            return (Criteria) this;
        }

        public Criteria andSignDateLessThan(Date value) {
            addCriterionForJDBCDate("sign_date <", value, "signDate");
            return (Criteria) this;
        }

        public Criteria andSignDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("sign_date <=", value, "signDate");
            return (Criteria) this;
        }

        public Criteria andSignDateIn(List<Date> values) {
            addCriterionForJDBCDate("sign_date in", values, "signDate");
            return (Criteria) this;
        }

        public Criteria andSignDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("sign_date not in", values, "signDate");
            return (Criteria) this;
        }

        public Criteria andSignDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("sign_date between", value1, value2, "signDate");
            return (Criteria) this;
        }

        public Criteria andSignDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("sign_date not between", value1, value2, "signDate");
            return (Criteria) this;
        }

        public Criteria andSignAddressIsNull() {
            addCriterion("sign_address is null");
            return (Criteria) this;
        }

        public Criteria andSignAddressIsNotNull() {
            addCriterion("sign_address is not null");
            return (Criteria) this;
        }

        public Criteria andSignAddressEqualTo(String value) {
            addCriterion("sign_address =", value, "signAddress");
            return (Criteria) this;
        }

        public Criteria andSignAddressNotEqualTo(String value) {
            addCriterion("sign_address <>", value, "signAddress");
            return (Criteria) this;
        }

        public Criteria andSignAddressGreaterThan(String value) {
            addCriterion("sign_address >", value, "signAddress");
            return (Criteria) this;
        }

        public Criteria andSignAddressGreaterThanOrEqualTo(String value) {
            addCriterion("sign_address >=", value, "signAddress");
            return (Criteria) this;
        }

        public Criteria andSignAddressLessThan(String value) {
            addCriterion("sign_address <", value, "signAddress");
            return (Criteria) this;
        }

        public Criteria andSignAddressLessThanOrEqualTo(String value) {
            addCriterion("sign_address <=", value, "signAddress");
            return (Criteria) this;
        }

        public Criteria andSignAddressLike(String value) {
            addCriterion("sign_address like", value, "signAddress");
            return (Criteria) this;
        }

        public Criteria andSignAddressNotLike(String value) {
            addCriterion("sign_address not like", value, "signAddress");
            return (Criteria) this;
        }

        public Criteria andSignAddressIn(List<String> values) {
            addCriterion("sign_address in", values, "signAddress");
            return (Criteria) this;
        }

        public Criteria andSignAddressNotIn(List<String> values) {
            addCriterion("sign_address not in", values, "signAddress");
            return (Criteria) this;
        }

        public Criteria andSignAddressBetween(String value1, String value2) {
            addCriterion("sign_address between", value1, value2, "signAddress");
            return (Criteria) this;
        }

        public Criteria andSignAddressNotBetween(String value1, String value2) {
            addCriterion("sign_address not between", value1, value2, "signAddress");
            return (Criteria) this;
        }

        public Criteria andContCodeIsNull() {
            addCriterion("cont_code is null");
            return (Criteria) this;
        }

        public Criteria andContCodeIsNotNull() {
            addCriterion("cont_code is not null");
            return (Criteria) this;
        }

        public Criteria andContCodeEqualTo(String value) {
            addCriterion("cont_code =", value, "contCode");
            return (Criteria) this;
        }

        public Criteria andContCodeNotEqualTo(String value) {
            addCriterion("cont_code <>", value, "contCode");
            return (Criteria) this;
        }

        public Criteria andContCodeGreaterThan(String value) {
            addCriterion("cont_code >", value, "contCode");
            return (Criteria) this;
        }

        public Criteria andContCodeGreaterThanOrEqualTo(String value) {
            addCriterion("cont_code >=", value, "contCode");
            return (Criteria) this;
        }

        public Criteria andContCodeLessThan(String value) {
            addCriterion("cont_code <", value, "contCode");
            return (Criteria) this;
        }

        public Criteria andContCodeLessThanOrEqualTo(String value) {
            addCriterion("cont_code <=", value, "contCode");
            return (Criteria) this;
        }

        public Criteria andContCodeLike(String value) {
            addCriterion("cont_code like", value, "contCode");
            return (Criteria) this;
        }

        public Criteria andContCodeNotLike(String value) {
            addCriterion("cont_code not like", value, "contCode");
            return (Criteria) this;
        }

        public Criteria andContCodeIn(List<String> values) {
            addCriterion("cont_code in", values, "contCode");
            return (Criteria) this;
        }

        public Criteria andContCodeNotIn(List<String> values) {
            addCriterion("cont_code not in", values, "contCode");
            return (Criteria) this;
        }

        public Criteria andContCodeBetween(String value1, String value2) {
            addCriterion("cont_code between", value1, value2, "contCode");
            return (Criteria) this;
        }

        public Criteria andContCodeNotBetween(String value1, String value2) {
            addCriterion("cont_code not between", value1, value2, "contCode");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeIsNull() {
            addCriterion("customer_contract_code is null");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeIsNotNull() {
            addCriterion("customer_contract_code is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeEqualTo(String value) {
            addCriterion("customer_contract_code =", value, "customerContractCode");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeNotEqualTo(String value) {
            addCriterion("customer_contract_code <>", value, "customerContractCode");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeGreaterThan(String value) {
            addCriterion("customer_contract_code >", value, "customerContractCode");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeGreaterThanOrEqualTo(String value) {
            addCriterion("customer_contract_code >=", value, "customerContractCode");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeLessThan(String value) {
            addCriterion("customer_contract_code <", value, "customerContractCode");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeLessThanOrEqualTo(String value) {
            addCriterion("customer_contract_code <=", value, "customerContractCode");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeLike(String value) {
            addCriterion("customer_contract_code like", value, "customerContractCode");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeNotLike(String value) {
            addCriterion("customer_contract_code not like", value, "customerContractCode");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeIn(List<String> values) {
            addCriterion("customer_contract_code in", values, "customerContractCode");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeNotIn(List<String> values) {
            addCriterion("customer_contract_code not in", values, "customerContractCode");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeBetween(String value1, String value2) {
            addCriterion("customer_contract_code between", value1, value2, "customerContractCode");
            return (Criteria) this;
        }

        public Criteria andCustomerContractCodeNotBetween(String value1, String value2) {
            addCriterion("customer_contract_code not between", value1, value2, "customerContractCode");
            return (Criteria) this;
        }

        public Criteria andPaymentIsNull() {
            addCriterion("payment is null");
            return (Criteria) this;
        }

        public Criteria andPaymentIsNotNull() {
            addCriterion("payment is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentEqualTo(Byte value) {
            addCriterion("payment =", value, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentNotEqualTo(Byte value) {
            addCriterion("payment <>", value, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentGreaterThan(Byte value) {
            addCriterion("payment >", value, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentGreaterThanOrEqualTo(Byte value) {
            addCriterion("payment >=", value, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentLessThan(Byte value) {
            addCriterion("payment <", value, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentLessThanOrEqualTo(Byte value) {
            addCriterion("payment <=", value, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentIn(List<Byte> values) {
            addCriterion("payment in", values, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentNotIn(List<Byte> values) {
            addCriterion("payment not in", values, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentBetween(Byte value1, Byte value2) {
            addCriterion("payment between", value1, value2, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentNotBetween(Byte value1, Byte value2) {
            addCriterion("payment not between", value1, value2, "payment");
            return (Criteria) this;
        }

        public Criteria andContTitleIsNull() {
            addCriterion("cont_title is null");
            return (Criteria) this;
        }

        public Criteria andContTitleIsNotNull() {
            addCriterion("cont_title is not null");
            return (Criteria) this;
        }

        public Criteria andContTitleEqualTo(String value) {
            addCriterion("cont_title =", value, "contTitle");
            return (Criteria) this;
        }

        public Criteria andContTitleNotEqualTo(String value) {
            addCriterion("cont_title <>", value, "contTitle");
            return (Criteria) this;
        }

        public Criteria andContTitleGreaterThan(String value) {
            addCriterion("cont_title >", value, "contTitle");
            return (Criteria) this;
        }

        public Criteria andContTitleGreaterThanOrEqualTo(String value) {
            addCriterion("cont_title >=", value, "contTitle");
            return (Criteria) this;
        }

        public Criteria andContTitleLessThan(String value) {
            addCriterion("cont_title <", value, "contTitle");
            return (Criteria) this;
        }

        public Criteria andContTitleLessThanOrEqualTo(String value) {
            addCriterion("cont_title <=", value, "contTitle");
            return (Criteria) this;
        }

        public Criteria andContTitleLike(String value) {
            addCriterion("cont_title like", value, "contTitle");
            return (Criteria) this;
        }

        public Criteria andContTitleNotLike(String value) {
            addCriterion("cont_title not like", value, "contTitle");
            return (Criteria) this;
        }

        public Criteria andContTitleIn(List<String> values) {
            addCriterion("cont_title in", values, "contTitle");
            return (Criteria) this;
        }

        public Criteria andContTitleNotIn(List<String> values) {
            addCriterion("cont_title not in", values, "contTitle");
            return (Criteria) this;
        }

        public Criteria andContTitleBetween(String value1, String value2) {
            addCriterion("cont_title between", value1, value2, "contTitle");
            return (Criteria) this;
        }

        public Criteria andContTitleNotBetween(String value1, String value2) {
            addCriterion("cont_title not between", value1, value2, "contTitle");
            return (Criteria) this;
        }

        public Criteria andPartyAUidIsNull() {
            addCriterion("party_a_uid is null");
            return (Criteria) this;
        }

        public Criteria andPartyAUidIsNotNull() {
            addCriterion("party_a_uid is not null");
            return (Criteria) this;
        }

        public Criteria andPartyAUidEqualTo(String value) {
            addCriterion("party_a_uid =", value, "partyAUid");
            return (Criteria) this;
        }

        public Criteria andPartyAUidNotEqualTo(String value) {
            addCriterion("party_a_uid <>", value, "partyAUid");
            return (Criteria) this;
        }

        public Criteria andPartyAUidGreaterThan(String value) {
            addCriterion("party_a_uid >", value, "partyAUid");
            return (Criteria) this;
        }

        public Criteria andPartyAUidGreaterThanOrEqualTo(String value) {
            addCriterion("party_a_uid >=", value, "partyAUid");
            return (Criteria) this;
        }

        public Criteria andPartyAUidLessThan(String value) {
            addCriterion("party_a_uid <", value, "partyAUid");
            return (Criteria) this;
        }

        public Criteria andPartyAUidLessThanOrEqualTo(String value) {
            addCriterion("party_a_uid <=", value, "partyAUid");
            return (Criteria) this;
        }

        public Criteria andPartyAUidLike(String value) {
            addCriterion("party_a_uid like", value, "partyAUid");
            return (Criteria) this;
        }

        public Criteria andPartyAUidNotLike(String value) {
            addCriterion("party_a_uid not like", value, "partyAUid");
            return (Criteria) this;
        }

        public Criteria andPartyAUidIn(List<String> values) {
            addCriterion("party_a_uid in", values, "partyAUid");
            return (Criteria) this;
        }

        public Criteria andPartyAUidNotIn(List<String> values) {
            addCriterion("party_a_uid not in", values, "partyAUid");
            return (Criteria) this;
        }

        public Criteria andPartyAUidBetween(String value1, String value2) {
            addCriterion("party_a_uid between", value1, value2, "partyAUid");
            return (Criteria) this;
        }

        public Criteria andPartyAUidNotBetween(String value1, String value2) {
            addCriterion("party_a_uid not between", value1, value2, "partyAUid");
            return (Criteria) this;
        }

        public Criteria andClientPartyAIsNull() {
            addCriterion("client_party_a is null");
            return (Criteria) this;
        }

        public Criteria andClientPartyAIsNotNull() {
            addCriterion("client_party_a is not null");
            return (Criteria) this;
        }

        public Criteria andClientPartyAEqualTo(String value) {
            addCriterion("client_party_a =", value, "clientPartyA");
            return (Criteria) this;
        }

        public Criteria andClientPartyANotEqualTo(String value) {
            addCriterion("client_party_a <>", value, "clientPartyA");
            return (Criteria) this;
        }

        public Criteria andClientPartyAGreaterThan(String value) {
            addCriterion("client_party_a >", value, "clientPartyA");
            return (Criteria) this;
        }

        public Criteria andClientPartyAGreaterThanOrEqualTo(String value) {
            addCriterion("client_party_a >=", value, "clientPartyA");
            return (Criteria) this;
        }

        public Criteria andClientPartyALessThan(String value) {
            addCriterion("client_party_a <", value, "clientPartyA");
            return (Criteria) this;
        }

        public Criteria andClientPartyALessThanOrEqualTo(String value) {
            addCriterion("client_party_a <=", value, "clientPartyA");
            return (Criteria) this;
        }

        public Criteria andClientPartyALike(String value) {
            addCriterion("client_party_a like", value, "clientPartyA");
            return (Criteria) this;
        }

        public Criteria andClientPartyANotLike(String value) {
            addCriterion("client_party_a not like", value, "clientPartyA");
            return (Criteria) this;
        }

        public Criteria andClientPartyAIn(List<String> values) {
            addCriterion("client_party_a in", values, "clientPartyA");
            return (Criteria) this;
        }

        public Criteria andClientPartyANotIn(List<String> values) {
            addCriterion("client_party_a not in", values, "clientPartyA");
            return (Criteria) this;
        }

        public Criteria andClientPartyABetween(String value1, String value2) {
            addCriterion("client_party_a between", value1, value2, "clientPartyA");
            return (Criteria) this;
        }

        public Criteria andClientPartyANotBetween(String value1, String value2) {
            addCriterion("client_party_a not between", value1, value2, "clientPartyA");
            return (Criteria) this;
        }

        public Criteria andContPartyAIsNull() {
            addCriterion("cont_party_a is null");
            return (Criteria) this;
        }

        public Criteria andContPartyAIsNotNull() {
            addCriterion("cont_party_a is not null");
            return (Criteria) this;
        }

        public Criteria andContPartyAEqualTo(String value) {
            addCriterion("cont_party_a =", value, "contPartyA");
            return (Criteria) this;
        }

        public Criteria andContPartyANotEqualTo(String value) {
            addCriterion("cont_party_a <>", value, "contPartyA");
            return (Criteria) this;
        }

        public Criteria andContPartyAGreaterThan(String value) {
            addCriterion("cont_party_a >", value, "contPartyA");
            return (Criteria) this;
        }

        public Criteria andContPartyAGreaterThanOrEqualTo(String value) {
            addCriterion("cont_party_a >=", value, "contPartyA");
            return (Criteria) this;
        }

        public Criteria andContPartyALessThan(String value) {
            addCriterion("cont_party_a <", value, "contPartyA");
            return (Criteria) this;
        }

        public Criteria andContPartyALessThanOrEqualTo(String value) {
            addCriterion("cont_party_a <=", value, "contPartyA");
            return (Criteria) this;
        }

        public Criteria andContPartyALike(String value) {
            addCriterion("cont_party_a like", value, "contPartyA");
            return (Criteria) this;
        }

        public Criteria andContPartyANotLike(String value) {
            addCriterion("cont_party_a not like", value, "contPartyA");
            return (Criteria) this;
        }

        public Criteria andContPartyAIn(List<String> values) {
            addCriterion("cont_party_a in", values, "contPartyA");
            return (Criteria) this;
        }

        public Criteria andContPartyANotIn(List<String> values) {
            addCriterion("cont_party_a not in", values, "contPartyA");
            return (Criteria) this;
        }

        public Criteria andContPartyABetween(String value1, String value2) {
            addCriterion("cont_party_a between", value1, value2, "contPartyA");
            return (Criteria) this;
        }

        public Criteria andContPartyANotBetween(String value1, String value2) {
            addCriterion("cont_party_a not between", value1, value2, "contPartyA");
            return (Criteria) this;
        }

        public Criteria andAddressPartyAIsNull() {
            addCriterion("address_party_a is null");
            return (Criteria) this;
        }

        public Criteria andAddressPartyAIsNotNull() {
            addCriterion("address_party_a is not null");
            return (Criteria) this;
        }

        public Criteria andAddressPartyAEqualTo(String value) {
            addCriterion("address_party_a =", value, "addressPartyA");
            return (Criteria) this;
        }

        public Criteria andAddressPartyANotEqualTo(String value) {
            addCriterion("address_party_a <>", value, "addressPartyA");
            return (Criteria) this;
        }

        public Criteria andAddressPartyAGreaterThan(String value) {
            addCriterion("address_party_a >", value, "addressPartyA");
            return (Criteria) this;
        }

        public Criteria andAddressPartyAGreaterThanOrEqualTo(String value) {
            addCriterion("address_party_a >=", value, "addressPartyA");
            return (Criteria) this;
        }

        public Criteria andAddressPartyALessThan(String value) {
            addCriterion("address_party_a <", value, "addressPartyA");
            return (Criteria) this;
        }

        public Criteria andAddressPartyALessThanOrEqualTo(String value) {
            addCriterion("address_party_a <=", value, "addressPartyA");
            return (Criteria) this;
        }

        public Criteria andAddressPartyALike(String value) {
            addCriterion("address_party_a like", value, "addressPartyA");
            return (Criteria) this;
        }

        public Criteria andAddressPartyANotLike(String value) {
            addCriterion("address_party_a not like", value, "addressPartyA");
            return (Criteria) this;
        }

        public Criteria andAddressPartyAIn(List<String> values) {
            addCriterion("address_party_a in", values, "addressPartyA");
            return (Criteria) this;
        }

        public Criteria andAddressPartyANotIn(List<String> values) {
            addCriterion("address_party_a not in", values, "addressPartyA");
            return (Criteria) this;
        }

        public Criteria andAddressPartyABetween(String value1, String value2) {
            addCriterion("address_party_a between", value1, value2, "addressPartyA");
            return (Criteria) this;
        }

        public Criteria andAddressPartyANotBetween(String value1, String value2) {
            addCriterion("address_party_a not between", value1, value2, "addressPartyA");
            return (Criteria) this;
        }

        public Criteria andPhonePartyAIsNull() {
            addCriterion("phone_party_a is null");
            return (Criteria) this;
        }

        public Criteria andPhonePartyAIsNotNull() {
            addCriterion("phone_party_a is not null");
            return (Criteria) this;
        }

        public Criteria andPhonePartyAEqualTo(String value) {
            addCriterion("phone_party_a =", value, "phonePartyA");
            return (Criteria) this;
        }

        public Criteria andPhonePartyANotEqualTo(String value) {
            addCriterion("phone_party_a <>", value, "phonePartyA");
            return (Criteria) this;
        }

        public Criteria andPhonePartyAGreaterThan(String value) {
            addCriterion("phone_party_a >", value, "phonePartyA");
            return (Criteria) this;
        }

        public Criteria andPhonePartyAGreaterThanOrEqualTo(String value) {
            addCriterion("phone_party_a >=", value, "phonePartyA");
            return (Criteria) this;
        }

        public Criteria andPhonePartyALessThan(String value) {
            addCriterion("phone_party_a <", value, "phonePartyA");
            return (Criteria) this;
        }

        public Criteria andPhonePartyALessThanOrEqualTo(String value) {
            addCriterion("phone_party_a <=", value, "phonePartyA");
            return (Criteria) this;
        }

        public Criteria andPhonePartyALike(String value) {
            addCriterion("phone_party_a like", value, "phonePartyA");
            return (Criteria) this;
        }

        public Criteria andPhonePartyANotLike(String value) {
            addCriterion("phone_party_a not like", value, "phonePartyA");
            return (Criteria) this;
        }

        public Criteria andPhonePartyAIn(List<String> values) {
            addCriterion("phone_party_a in", values, "phonePartyA");
            return (Criteria) this;
        }

        public Criteria andPhonePartyANotIn(List<String> values) {
            addCriterion("phone_party_a not in", values, "phonePartyA");
            return (Criteria) this;
        }

        public Criteria andPhonePartyABetween(String value1, String value2) {
            addCriterion("phone_party_a between", value1, value2, "phonePartyA");
            return (Criteria) this;
        }

        public Criteria andPhonePartyANotBetween(String value1, String value2) {
            addCriterion("phone_party_a not between", value1, value2, "phonePartyA");
            return (Criteria) this;
        }

        public Criteria andFaxPartyAIsNull() {
            addCriterion("fax_party_a is null");
            return (Criteria) this;
        }

        public Criteria andFaxPartyAIsNotNull() {
            addCriterion("fax_party_a is not null");
            return (Criteria) this;
        }

        public Criteria andFaxPartyAEqualTo(String value) {
            addCriterion("fax_party_a =", value, "faxPartyA");
            return (Criteria) this;
        }

        public Criteria andFaxPartyANotEqualTo(String value) {
            addCriterion("fax_party_a <>", value, "faxPartyA");
            return (Criteria) this;
        }

        public Criteria andFaxPartyAGreaterThan(String value) {
            addCriterion("fax_party_a >", value, "faxPartyA");
            return (Criteria) this;
        }

        public Criteria andFaxPartyAGreaterThanOrEqualTo(String value) {
            addCriterion("fax_party_a >=", value, "faxPartyA");
            return (Criteria) this;
        }

        public Criteria andFaxPartyALessThan(String value) {
            addCriterion("fax_party_a <", value, "faxPartyA");
            return (Criteria) this;
        }

        public Criteria andFaxPartyALessThanOrEqualTo(String value) {
            addCriterion("fax_party_a <=", value, "faxPartyA");
            return (Criteria) this;
        }

        public Criteria andFaxPartyALike(String value) {
            addCriterion("fax_party_a like", value, "faxPartyA");
            return (Criteria) this;
        }

        public Criteria andFaxPartyANotLike(String value) {
            addCriterion("fax_party_a not like", value, "faxPartyA");
            return (Criteria) this;
        }

        public Criteria andFaxPartyAIn(List<String> values) {
            addCriterion("fax_party_a in", values, "faxPartyA");
            return (Criteria) this;
        }

        public Criteria andFaxPartyANotIn(List<String> values) {
            addCriterion("fax_party_a not in", values, "faxPartyA");
            return (Criteria) this;
        }

        public Criteria andFaxPartyABetween(String value1, String value2) {
            addCriterion("fax_party_a between", value1, value2, "faxPartyA");
            return (Criteria) this;
        }

        public Criteria andFaxPartyANotBetween(String value1, String value2) {
            addCriterion("fax_party_a not between", value1, value2, "faxPartyA");
            return (Criteria) this;
        }

        public Criteria andEmailPartyAIsNull() {
            addCriterion("email_party_a is null");
            return (Criteria) this;
        }

        public Criteria andEmailPartyAIsNotNull() {
            addCriterion("email_party_a is not null");
            return (Criteria) this;
        }

        public Criteria andEmailPartyAEqualTo(String value) {
            addCriterion("email_party_a =", value, "emailPartyA");
            return (Criteria) this;
        }

        public Criteria andEmailPartyANotEqualTo(String value) {
            addCriterion("email_party_a <>", value, "emailPartyA");
            return (Criteria) this;
        }

        public Criteria andEmailPartyAGreaterThan(String value) {
            addCriterion("email_party_a >", value, "emailPartyA");
            return (Criteria) this;
        }

        public Criteria andEmailPartyAGreaterThanOrEqualTo(String value) {
            addCriterion("email_party_a >=", value, "emailPartyA");
            return (Criteria) this;
        }

        public Criteria andEmailPartyALessThan(String value) {
            addCriterion("email_party_a <", value, "emailPartyA");
            return (Criteria) this;
        }

        public Criteria andEmailPartyALessThanOrEqualTo(String value) {
            addCriterion("email_party_a <=", value, "emailPartyA");
            return (Criteria) this;
        }

        public Criteria andEmailPartyALike(String value) {
            addCriterion("email_party_a like", value, "emailPartyA");
            return (Criteria) this;
        }

        public Criteria andEmailPartyANotLike(String value) {
            addCriterion("email_party_a not like", value, "emailPartyA");
            return (Criteria) this;
        }

        public Criteria andEmailPartyAIn(List<String> values) {
            addCriterion("email_party_a in", values, "emailPartyA");
            return (Criteria) this;
        }

        public Criteria andEmailPartyANotIn(List<String> values) {
            addCriterion("email_party_a not in", values, "emailPartyA");
            return (Criteria) this;
        }

        public Criteria andEmailPartyABetween(String value1, String value2) {
            addCriterion("email_party_a between", value1, value2, "emailPartyA");
            return (Criteria) this;
        }

        public Criteria andEmailPartyANotBetween(String value1, String value2) {
            addCriterion("email_party_a not between", value1, value2, "emailPartyA");
            return (Criteria) this;
        }

        public Criteria andBankPartyAIsNull() {
            addCriterion("bank_party_a is null");
            return (Criteria) this;
        }

        public Criteria andBankPartyAIsNotNull() {
            addCriterion("bank_party_a is not null");
            return (Criteria) this;
        }

        public Criteria andBankPartyAEqualTo(String value) {
            addCriterion("bank_party_a =", value, "bankPartyA");
            return (Criteria) this;
        }

        public Criteria andBankPartyANotEqualTo(String value) {
            addCriterion("bank_party_a <>", value, "bankPartyA");
            return (Criteria) this;
        }

        public Criteria andBankPartyAGreaterThan(String value) {
            addCriterion("bank_party_a >", value, "bankPartyA");
            return (Criteria) this;
        }

        public Criteria andBankPartyAGreaterThanOrEqualTo(String value) {
            addCriterion("bank_party_a >=", value, "bankPartyA");
            return (Criteria) this;
        }

        public Criteria andBankPartyALessThan(String value) {
            addCriterion("bank_party_a <", value, "bankPartyA");
            return (Criteria) this;
        }

        public Criteria andBankPartyALessThanOrEqualTo(String value) {
            addCriterion("bank_party_a <=", value, "bankPartyA");
            return (Criteria) this;
        }

        public Criteria andBankPartyALike(String value) {
            addCriterion("bank_party_a like", value, "bankPartyA");
            return (Criteria) this;
        }

        public Criteria andBankPartyANotLike(String value) {
            addCriterion("bank_party_a not like", value, "bankPartyA");
            return (Criteria) this;
        }

        public Criteria andBankPartyAIn(List<String> values) {
            addCriterion("bank_party_a in", values, "bankPartyA");
            return (Criteria) this;
        }

        public Criteria andBankPartyANotIn(List<String> values) {
            addCriterion("bank_party_a not in", values, "bankPartyA");
            return (Criteria) this;
        }

        public Criteria andBankPartyABetween(String value1, String value2) {
            addCriterion("bank_party_a between", value1, value2, "bankPartyA");
            return (Criteria) this;
        }

        public Criteria andBankPartyANotBetween(String value1, String value2) {
            addCriterion("bank_party_a not between", value1, value2, "bankPartyA");
            return (Criteria) this;
        }

        public Criteria andAccountPartAIsNull() {
            addCriterion("account_part_a is null");
            return (Criteria) this;
        }

        public Criteria andAccountPartAIsNotNull() {
            addCriterion("account_part_a is not null");
            return (Criteria) this;
        }

        public Criteria andAccountPartAEqualTo(String value) {
            addCriterion("account_part_a =", value, "accountPartA");
            return (Criteria) this;
        }

        public Criteria andAccountPartANotEqualTo(String value) {
            addCriterion("account_part_a <>", value, "accountPartA");
            return (Criteria) this;
        }

        public Criteria andAccountPartAGreaterThan(String value) {
            addCriterion("account_part_a >", value, "accountPartA");
            return (Criteria) this;
        }

        public Criteria andAccountPartAGreaterThanOrEqualTo(String value) {
            addCriterion("account_part_a >=", value, "accountPartA");
            return (Criteria) this;
        }

        public Criteria andAccountPartALessThan(String value) {
            addCriterion("account_part_a <", value, "accountPartA");
            return (Criteria) this;
        }

        public Criteria andAccountPartALessThanOrEqualTo(String value) {
            addCriterion("account_part_a <=", value, "accountPartA");
            return (Criteria) this;
        }

        public Criteria andAccountPartALike(String value) {
            addCriterion("account_part_a like", value, "accountPartA");
            return (Criteria) this;
        }

        public Criteria andAccountPartANotLike(String value) {
            addCriterion("account_part_a not like", value, "accountPartA");
            return (Criteria) this;
        }

        public Criteria andAccountPartAIn(List<String> values) {
            addCriterion("account_part_a in", values, "accountPartA");
            return (Criteria) this;
        }

        public Criteria andAccountPartANotIn(List<String> values) {
            addCriterion("account_part_a not in", values, "accountPartA");
            return (Criteria) this;
        }

        public Criteria andAccountPartABetween(String value1, String value2) {
            addCriterion("account_part_a between", value1, value2, "accountPartA");
            return (Criteria) this;
        }

        public Criteria andAccountPartANotBetween(String value1, String value2) {
            addCriterion("account_part_a not between", value1, value2, "accountPartA");
            return (Criteria) this;
        }

        public Criteria andTariffPartyAIsNull() {
            addCriterion("tariff_party_a is null");
            return (Criteria) this;
        }

        public Criteria andTariffPartyAIsNotNull() {
            addCriterion("tariff_party_a is not null");
            return (Criteria) this;
        }

        public Criteria andTariffPartyAEqualTo(String value) {
            addCriterion("tariff_party_a =", value, "tariffPartyA");
            return (Criteria) this;
        }

        public Criteria andTariffPartyANotEqualTo(String value) {
            addCriterion("tariff_party_a <>", value, "tariffPartyA");
            return (Criteria) this;
        }

        public Criteria andTariffPartyAGreaterThan(String value) {
            addCriterion("tariff_party_a >", value, "tariffPartyA");
            return (Criteria) this;
        }

        public Criteria andTariffPartyAGreaterThanOrEqualTo(String value) {
            addCriterion("tariff_party_a >=", value, "tariffPartyA");
            return (Criteria) this;
        }

        public Criteria andTariffPartyALessThan(String value) {
            addCriterion("tariff_party_a <", value, "tariffPartyA");
            return (Criteria) this;
        }

        public Criteria andTariffPartyALessThanOrEqualTo(String value) {
            addCriterion("tariff_party_a <=", value, "tariffPartyA");
            return (Criteria) this;
        }

        public Criteria andTariffPartyALike(String value) {
            addCriterion("tariff_party_a like", value, "tariffPartyA");
            return (Criteria) this;
        }

        public Criteria andTariffPartyANotLike(String value) {
            addCriterion("tariff_party_a not like", value, "tariffPartyA");
            return (Criteria) this;
        }

        public Criteria andTariffPartyAIn(List<String> values) {
            addCriterion("tariff_party_a in", values, "tariffPartyA");
            return (Criteria) this;
        }

        public Criteria andTariffPartyANotIn(List<String> values) {
            addCriterion("tariff_party_a not in", values, "tariffPartyA");
            return (Criteria) this;
        }

        public Criteria andTariffPartyABetween(String value1, String value2) {
            addCriterion("tariff_party_a between", value1, value2, "tariffPartyA");
            return (Criteria) this;
        }

        public Criteria andTariffPartyANotBetween(String value1, String value2) {
            addCriterion("tariff_party_a not between", value1, value2, "tariffPartyA");
            return (Criteria) this;
        }

        public Criteria andPartyBUidIsNull() {
            addCriterion("party_b_uid is null");
            return (Criteria) this;
        }

        public Criteria andPartyBUidIsNotNull() {
            addCriterion("party_b_uid is not null");
            return (Criteria) this;
        }

        public Criteria andPartyBUidEqualTo(String value) {
            addCriterion("party_b_uid =", value, "partyBUid");
            return (Criteria) this;
        }

        public Criteria andPartyBUidNotEqualTo(String value) {
            addCriterion("party_b_uid <>", value, "partyBUid");
            return (Criteria) this;
        }

        public Criteria andPartyBUidGreaterThan(String value) {
            addCriterion("party_b_uid >", value, "partyBUid");
            return (Criteria) this;
        }

        public Criteria andPartyBUidGreaterThanOrEqualTo(String value) {
            addCriterion("party_b_uid >=", value, "partyBUid");
            return (Criteria) this;
        }

        public Criteria andPartyBUidLessThan(String value) {
            addCriterion("party_b_uid <", value, "partyBUid");
            return (Criteria) this;
        }

        public Criteria andPartyBUidLessThanOrEqualTo(String value) {
            addCriterion("party_b_uid <=", value, "partyBUid");
            return (Criteria) this;
        }

        public Criteria andPartyBUidLike(String value) {
            addCriterion("party_b_uid like", value, "partyBUid");
            return (Criteria) this;
        }

        public Criteria andPartyBUidNotLike(String value) {
            addCriterion("party_b_uid not like", value, "partyBUid");
            return (Criteria) this;
        }

        public Criteria andPartyBUidIn(List<String> values) {
            addCriterion("party_b_uid in", values, "partyBUid");
            return (Criteria) this;
        }

        public Criteria andPartyBUidNotIn(List<String> values) {
            addCriterion("party_b_uid not in", values, "partyBUid");
            return (Criteria) this;
        }

        public Criteria andPartyBUidBetween(String value1, String value2) {
            addCriterion("party_b_uid between", value1, value2, "partyBUid");
            return (Criteria) this;
        }

        public Criteria andPartyBUidNotBetween(String value1, String value2) {
            addCriterion("party_b_uid not between", value1, value2, "partyBUid");
            return (Criteria) this;
        }

        public Criteria andClientPartyBIsNull() {
            addCriterion("client_party_b is null");
            return (Criteria) this;
        }

        public Criteria andClientPartyBIsNotNull() {
            addCriterion("client_party_b is not null");
            return (Criteria) this;
        }

        public Criteria andClientPartyBEqualTo(String value) {
            addCriterion("client_party_b =", value, "clientPartyB");
            return (Criteria) this;
        }

        public Criteria andClientPartyBNotEqualTo(String value) {
            addCriterion("client_party_b <>", value, "clientPartyB");
            return (Criteria) this;
        }

        public Criteria andClientPartyBGreaterThan(String value) {
            addCriterion("client_party_b >", value, "clientPartyB");
            return (Criteria) this;
        }

        public Criteria andClientPartyBGreaterThanOrEqualTo(String value) {
            addCriterion("client_party_b >=", value, "clientPartyB");
            return (Criteria) this;
        }

        public Criteria andClientPartyBLessThan(String value) {
            addCriterion("client_party_b <", value, "clientPartyB");
            return (Criteria) this;
        }

        public Criteria andClientPartyBLessThanOrEqualTo(String value) {
            addCriterion("client_party_b <=", value, "clientPartyB");
            return (Criteria) this;
        }

        public Criteria andClientPartyBLike(String value) {
            addCriterion("client_party_b like", value, "clientPartyB");
            return (Criteria) this;
        }

        public Criteria andClientPartyBNotLike(String value) {
            addCriterion("client_party_b not like", value, "clientPartyB");
            return (Criteria) this;
        }

        public Criteria andClientPartyBIn(List<String> values) {
            addCriterion("client_party_b in", values, "clientPartyB");
            return (Criteria) this;
        }

        public Criteria andClientPartyBNotIn(List<String> values) {
            addCriterion("client_party_b not in", values, "clientPartyB");
            return (Criteria) this;
        }

        public Criteria andClientPartyBBetween(String value1, String value2) {
            addCriterion("client_party_b between", value1, value2, "clientPartyB");
            return (Criteria) this;
        }

        public Criteria andClientPartyBNotBetween(String value1, String value2) {
            addCriterion("client_party_b not between", value1, value2, "clientPartyB");
            return (Criteria) this;
        }

        public Criteria andContPartyBIsNull() {
            addCriterion("cont_party_b is null");
            return (Criteria) this;
        }

        public Criteria andContPartyBIsNotNull() {
            addCriterion("cont_party_b is not null");
            return (Criteria) this;
        }

        public Criteria andContPartyBEqualTo(String value) {
            addCriterion("cont_party_b =", value, "contPartyB");
            return (Criteria) this;
        }

        public Criteria andContPartyBNotEqualTo(String value) {
            addCriterion("cont_party_b <>", value, "contPartyB");
            return (Criteria) this;
        }

        public Criteria andContPartyBGreaterThan(String value) {
            addCriterion("cont_party_b >", value, "contPartyB");
            return (Criteria) this;
        }

        public Criteria andContPartyBGreaterThanOrEqualTo(String value) {
            addCriterion("cont_party_b >=", value, "contPartyB");
            return (Criteria) this;
        }

        public Criteria andContPartyBLessThan(String value) {
            addCriterion("cont_party_b <", value, "contPartyB");
            return (Criteria) this;
        }

        public Criteria andContPartyBLessThanOrEqualTo(String value) {
            addCriterion("cont_party_b <=", value, "contPartyB");
            return (Criteria) this;
        }

        public Criteria andContPartyBLike(String value) {
            addCriterion("cont_party_b like", value, "contPartyB");
            return (Criteria) this;
        }

        public Criteria andContPartyBNotLike(String value) {
            addCriterion("cont_party_b not like", value, "contPartyB");
            return (Criteria) this;
        }

        public Criteria andContPartyBIn(List<String> values) {
            addCriterion("cont_party_b in", values, "contPartyB");
            return (Criteria) this;
        }

        public Criteria andContPartyBNotIn(List<String> values) {
            addCriterion("cont_party_b not in", values, "contPartyB");
            return (Criteria) this;
        }

        public Criteria andContPartyBBetween(String value1, String value2) {
            addCriterion("cont_party_b between", value1, value2, "contPartyB");
            return (Criteria) this;
        }

        public Criteria andContPartyBNotBetween(String value1, String value2) {
            addCriterion("cont_party_b not between", value1, value2, "contPartyB");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBIsNull() {
            addCriterion("address_party_b is null");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBIsNotNull() {
            addCriterion("address_party_b is not null");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBEqualTo(String value) {
            addCriterion("address_party_b =", value, "addressPartyB");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBNotEqualTo(String value) {
            addCriterion("address_party_b <>", value, "addressPartyB");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBGreaterThan(String value) {
            addCriterion("address_party_b >", value, "addressPartyB");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBGreaterThanOrEqualTo(String value) {
            addCriterion("address_party_b >=", value, "addressPartyB");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBLessThan(String value) {
            addCriterion("address_party_b <", value, "addressPartyB");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBLessThanOrEqualTo(String value) {
            addCriterion("address_party_b <=", value, "addressPartyB");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBLike(String value) {
            addCriterion("address_party_b like", value, "addressPartyB");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBNotLike(String value) {
            addCriterion("address_party_b not like", value, "addressPartyB");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBIn(List<String> values) {
            addCriterion("address_party_b in", values, "addressPartyB");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBNotIn(List<String> values) {
            addCriterion("address_party_b not in", values, "addressPartyB");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBBetween(String value1, String value2) {
            addCriterion("address_party_b between", value1, value2, "addressPartyB");
            return (Criteria) this;
        }

        public Criteria andAddressPartyBNotBetween(String value1, String value2) {
            addCriterion("address_party_b not between", value1, value2, "addressPartyB");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBIsNull() {
            addCriterion("phone_party_b is null");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBIsNotNull() {
            addCriterion("phone_party_b is not null");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBEqualTo(String value) {
            addCriterion("phone_party_b =", value, "phonePartyB");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBNotEqualTo(String value) {
            addCriterion("phone_party_b <>", value, "phonePartyB");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBGreaterThan(String value) {
            addCriterion("phone_party_b >", value, "phonePartyB");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBGreaterThanOrEqualTo(String value) {
            addCriterion("phone_party_b >=", value, "phonePartyB");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBLessThan(String value) {
            addCriterion("phone_party_b <", value, "phonePartyB");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBLessThanOrEqualTo(String value) {
            addCriterion("phone_party_b <=", value, "phonePartyB");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBLike(String value) {
            addCriterion("phone_party_b like", value, "phonePartyB");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBNotLike(String value) {
            addCriterion("phone_party_b not like", value, "phonePartyB");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBIn(List<String> values) {
            addCriterion("phone_party_b in", values, "phonePartyB");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBNotIn(List<String> values) {
            addCriterion("phone_party_b not in", values, "phonePartyB");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBBetween(String value1, String value2) {
            addCriterion("phone_party_b between", value1, value2, "phonePartyB");
            return (Criteria) this;
        }

        public Criteria andPhonePartyBNotBetween(String value1, String value2) {
            addCriterion("phone_party_b not between", value1, value2, "phonePartyB");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBIsNull() {
            addCriterion("fax_party_b is null");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBIsNotNull() {
            addCriterion("fax_party_b is not null");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBEqualTo(String value) {
            addCriterion("fax_party_b =", value, "faxPartyB");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBNotEqualTo(String value) {
            addCriterion("fax_party_b <>", value, "faxPartyB");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBGreaterThan(String value) {
            addCriterion("fax_party_b >", value, "faxPartyB");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBGreaterThanOrEqualTo(String value) {
            addCriterion("fax_party_b >=", value, "faxPartyB");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBLessThan(String value) {
            addCriterion("fax_party_b <", value, "faxPartyB");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBLessThanOrEqualTo(String value) {
            addCriterion("fax_party_b <=", value, "faxPartyB");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBLike(String value) {
            addCriterion("fax_party_b like", value, "faxPartyB");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBNotLike(String value) {
            addCriterion("fax_party_b not like", value, "faxPartyB");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBIn(List<String> values) {
            addCriterion("fax_party_b in", values, "faxPartyB");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBNotIn(List<String> values) {
            addCriterion("fax_party_b not in", values, "faxPartyB");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBBetween(String value1, String value2) {
            addCriterion("fax_party_b between", value1, value2, "faxPartyB");
            return (Criteria) this;
        }

        public Criteria andFaxPartyBNotBetween(String value1, String value2) {
            addCriterion("fax_party_b not between", value1, value2, "faxPartyB");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBIsNull() {
            addCriterion("email_party_b is null");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBIsNotNull() {
            addCriterion("email_party_b is not null");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBEqualTo(String value) {
            addCriterion("email_party_b =", value, "emailPartyB");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBNotEqualTo(String value) {
            addCriterion("email_party_b <>", value, "emailPartyB");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBGreaterThan(String value) {
            addCriterion("email_party_b >", value, "emailPartyB");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBGreaterThanOrEqualTo(String value) {
            addCriterion("email_party_b >=", value, "emailPartyB");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBLessThan(String value) {
            addCriterion("email_party_b <", value, "emailPartyB");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBLessThanOrEqualTo(String value) {
            addCriterion("email_party_b <=", value, "emailPartyB");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBLike(String value) {
            addCriterion("email_party_b like", value, "emailPartyB");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBNotLike(String value) {
            addCriterion("email_party_b not like", value, "emailPartyB");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBIn(List<String> values) {
            addCriterion("email_party_b in", values, "emailPartyB");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBNotIn(List<String> values) {
            addCriterion("email_party_b not in", values, "emailPartyB");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBBetween(String value1, String value2) {
            addCriterion("email_party_b between", value1, value2, "emailPartyB");
            return (Criteria) this;
        }

        public Criteria andEmailPartyBNotBetween(String value1, String value2) {
            addCriterion("email_party_b not between", value1, value2, "emailPartyB");
            return (Criteria) this;
        }

        public Criteria andBankPartyBIsNull() {
            addCriterion("bank_party_b is null");
            return (Criteria) this;
        }

        public Criteria andBankPartyBIsNotNull() {
            addCriterion("bank_party_b is not null");
            return (Criteria) this;
        }

        public Criteria andBankPartyBEqualTo(String value) {
            addCriterion("bank_party_b =", value, "bankPartyB");
            return (Criteria) this;
        }

        public Criteria andBankPartyBNotEqualTo(String value) {
            addCriterion("bank_party_b <>", value, "bankPartyB");
            return (Criteria) this;
        }

        public Criteria andBankPartyBGreaterThan(String value) {
            addCriterion("bank_party_b >", value, "bankPartyB");
            return (Criteria) this;
        }

        public Criteria andBankPartyBGreaterThanOrEqualTo(String value) {
            addCriterion("bank_party_b >=", value, "bankPartyB");
            return (Criteria) this;
        }

        public Criteria andBankPartyBLessThan(String value) {
            addCriterion("bank_party_b <", value, "bankPartyB");
            return (Criteria) this;
        }

        public Criteria andBankPartyBLessThanOrEqualTo(String value) {
            addCriterion("bank_party_b <=", value, "bankPartyB");
            return (Criteria) this;
        }

        public Criteria andBankPartyBLike(String value) {
            addCriterion("bank_party_b like", value, "bankPartyB");
            return (Criteria) this;
        }

        public Criteria andBankPartyBNotLike(String value) {
            addCriterion("bank_party_b not like", value, "bankPartyB");
            return (Criteria) this;
        }

        public Criteria andBankPartyBIn(List<String> values) {
            addCriterion("bank_party_b in", values, "bankPartyB");
            return (Criteria) this;
        }

        public Criteria andBankPartyBNotIn(List<String> values) {
            addCriterion("bank_party_b not in", values, "bankPartyB");
            return (Criteria) this;
        }

        public Criteria andBankPartyBBetween(String value1, String value2) {
            addCriterion("bank_party_b between", value1, value2, "bankPartyB");
            return (Criteria) this;
        }

        public Criteria andBankPartyBNotBetween(String value1, String value2) {
            addCriterion("bank_party_b not between", value1, value2, "bankPartyB");
            return (Criteria) this;
        }

        public Criteria andAccountPartBIsNull() {
            addCriterion("account_part_b is null");
            return (Criteria) this;
        }

        public Criteria andAccountPartBIsNotNull() {
            addCriterion("account_part_b is not null");
            return (Criteria) this;
        }

        public Criteria andAccountPartBEqualTo(String value) {
            addCriterion("account_part_b =", value, "accountPartB");
            return (Criteria) this;
        }

        public Criteria andAccountPartBNotEqualTo(String value) {
            addCriterion("account_part_b <>", value, "accountPartB");
            return (Criteria) this;
        }

        public Criteria andAccountPartBGreaterThan(String value) {
            addCriterion("account_part_b >", value, "accountPartB");
            return (Criteria) this;
        }

        public Criteria andAccountPartBGreaterThanOrEqualTo(String value) {
            addCriterion("account_part_b >=", value, "accountPartB");
            return (Criteria) this;
        }

        public Criteria andAccountPartBLessThan(String value) {
            addCriterion("account_part_b <", value, "accountPartB");
            return (Criteria) this;
        }

        public Criteria andAccountPartBLessThanOrEqualTo(String value) {
            addCriterion("account_part_b <=", value, "accountPartB");
            return (Criteria) this;
        }

        public Criteria andAccountPartBLike(String value) {
            addCriterion("account_part_b like", value, "accountPartB");
            return (Criteria) this;
        }

        public Criteria andAccountPartBNotLike(String value) {
            addCriterion("account_part_b not like", value, "accountPartB");
            return (Criteria) this;
        }

        public Criteria andAccountPartBIn(List<String> values) {
            addCriterion("account_part_b in", values, "accountPartB");
            return (Criteria) this;
        }

        public Criteria andAccountPartBNotIn(List<String> values) {
            addCriterion("account_part_b not in", values, "accountPartB");
            return (Criteria) this;
        }

        public Criteria andAccountPartBBetween(String value1, String value2) {
            addCriterion("account_part_b between", value1, value2, "accountPartB");
            return (Criteria) this;
        }

        public Criteria andAccountPartBNotBetween(String value1, String value2) {
            addCriterion("account_part_b not between", value1, value2, "accountPartB");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBIsNull() {
            addCriterion("tariff_party_b is null");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBIsNotNull() {
            addCriterion("tariff_party_b is not null");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBEqualTo(String value) {
            addCriterion("tariff_party_b =", value, "tariffPartyB");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBNotEqualTo(String value) {
            addCriterion("tariff_party_b <>", value, "tariffPartyB");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBGreaterThan(String value) {
            addCriterion("tariff_party_b >", value, "tariffPartyB");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBGreaterThanOrEqualTo(String value) {
            addCriterion("tariff_party_b >=", value, "tariffPartyB");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBLessThan(String value) {
            addCriterion("tariff_party_b <", value, "tariffPartyB");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBLessThanOrEqualTo(String value) {
            addCriterion("tariff_party_b <=", value, "tariffPartyB");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBLike(String value) {
            addCriterion("tariff_party_b like", value, "tariffPartyB");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBNotLike(String value) {
            addCriterion("tariff_party_b not like", value, "tariffPartyB");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBIn(List<String> values) {
            addCriterion("tariff_party_b in", values, "tariffPartyB");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBNotIn(List<String> values) {
            addCriterion("tariff_party_b not in", values, "tariffPartyB");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBBetween(String value1, String value2) {
            addCriterion("tariff_party_b between", value1, value2, "tariffPartyB");
            return (Criteria) this;
        }

        public Criteria andTariffPartyBNotBetween(String value1, String value2) {
            addCriterion("tariff_party_b not between", value1, value2, "tariffPartyB");
            return (Criteria) this;
        }

        public Criteria andTaxIsNull() {
            addCriterion("tax is null");
            return (Criteria) this;
        }

        public Criteria andTaxIsNotNull() {
            addCriterion("tax is not null");
            return (Criteria) this;
        }

        public Criteria andTaxEqualTo(Long value) {
            addCriterion("tax =", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotEqualTo(Long value) {
            addCriterion("tax <>", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxGreaterThan(Long value) {
            addCriterion("tax >", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxGreaterThanOrEqualTo(Long value) {
            addCriterion("tax >=", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxLessThan(Long value) {
            addCriterion("tax <", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxLessThanOrEqualTo(Long value) {
            addCriterion("tax <=", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxIn(List<Long> values) {
            addCriterion("tax in", values, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotIn(List<Long> values) {
            addCriterion("tax not in", values, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxBetween(Long value1, Long value2) {
            addCriterion("tax between", value1, value2, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotBetween(Long value1, Long value2) {
            addCriterion("tax not between", value1, value2, "tax");
            return (Criteria) this;
        }

        public Criteria andAmountRmbIsNull() {
            addCriterion("amount_rmb is null");
            return (Criteria) this;
        }

        public Criteria andAmountRmbIsNotNull() {
            addCriterion("amount_rmb is not null");
            return (Criteria) this;
        }

        public Criteria andAmountRmbEqualTo(Long value) {
            addCriterion("amount_rmb =", value, "amountRmb");
            return (Criteria) this;
        }

        public Criteria andAmountRmbNotEqualTo(Long value) {
            addCriterion("amount_rmb <>", value, "amountRmb");
            return (Criteria) this;
        }

        public Criteria andAmountRmbGreaterThan(Long value) {
            addCriterion("amount_rmb >", value, "amountRmb");
            return (Criteria) this;
        }

        public Criteria andAmountRmbGreaterThanOrEqualTo(Long value) {
            addCriterion("amount_rmb >=", value, "amountRmb");
            return (Criteria) this;
        }

        public Criteria andAmountRmbLessThan(Long value) {
            addCriterion("amount_rmb <", value, "amountRmb");
            return (Criteria) this;
        }

        public Criteria andAmountRmbLessThanOrEqualTo(Long value) {
            addCriterion("amount_rmb <=", value, "amountRmb");
            return (Criteria) this;
        }

        public Criteria andAmountRmbIn(List<Long> values) {
            addCriterion("amount_rmb in", values, "amountRmb");
            return (Criteria) this;
        }

        public Criteria andAmountRmbNotIn(List<Long> values) {
            addCriterion("amount_rmb not in", values, "amountRmb");
            return (Criteria) this;
        }

        public Criteria andAmountRmbBetween(Long value1, Long value2) {
            addCriterion("amount_rmb between", value1, value2, "amountRmb");
            return (Criteria) this;
        }

        public Criteria andAmountRmbNotBetween(Long value1, Long value2) {
            addCriterion("amount_rmb not between", value1, value2, "amountRmb");
            return (Criteria) this;
        }

        public Criteria andAmountIsNull() {
            addCriterion("amount is null");
            return (Criteria) this;
        }

        public Criteria andAmountIsNotNull() {
            addCriterion("amount is not null");
            return (Criteria) this;
        }

        public Criteria andAmountEqualTo(Long value) {
            addCriterion("amount =", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotEqualTo(Long value) {
            addCriterion("amount <>", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThan(Long value) {
            addCriterion("amount >", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThanOrEqualTo(Long value) {
            addCriterion("amount >=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThan(Long value) {
            addCriterion("amount <", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThanOrEqualTo(Long value) {
            addCriterion("amount <=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountIn(List<Long> values) {
            addCriterion("amount in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotIn(List<Long> values) {
            addCriterion("amount not in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountBetween(Long value1, Long value2) {
            addCriterion("amount between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotBetween(Long value1, Long value2) {
            addCriterion("amount not between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNull() {
            addCriterion("currency is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNotNull() {
            addCriterion("currency is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyEqualTo(String value) {
            addCriterion("currency =", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotEqualTo(String value) {
            addCriterion("currency <>", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThan(String value) {
            addCriterion("currency >", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThanOrEqualTo(String value) {
            addCriterion("currency >=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThan(String value) {
            addCriterion("currency <", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThanOrEqualTo(String value) {
            addCriterion("currency <=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLike(String value) {
            addCriterion("currency like", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotLike(String value) {
            addCriterion("currency not like", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyIn(List<String> values) {
            addCriterion("currency in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotIn(List<String> values) {
            addCriterion("currency not in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyBetween(String value1, String value2) {
            addCriterion("currency between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotBetween(String value1, String value2) {
            addCriterion("currency not between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andExchangeRateIsNull() {
            addCriterion("exchange_rate is null");
            return (Criteria) this;
        }

        public Criteria andExchangeRateIsNotNull() {
            addCriterion("exchange_rate is not null");
            return (Criteria) this;
        }

        public Criteria andExchangeRateEqualTo(Long value) {
            addCriterion("exchange_rate =", value, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateNotEqualTo(Long value) {
            addCriterion("exchange_rate <>", value, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateGreaterThan(Long value) {
            addCriterion("exchange_rate >", value, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateGreaterThanOrEqualTo(Long value) {
            addCriterion("exchange_rate >=", value, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateLessThan(Long value) {
            addCriterion("exchange_rate <", value, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateLessThanOrEqualTo(Long value) {
            addCriterion("exchange_rate <=", value, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateIn(List<Long> values) {
            addCriterion("exchange_rate in", values, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateNotIn(List<Long> values) {
            addCriterion("exchange_rate not in", values, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateBetween(Long value1, Long value2) {
            addCriterion("exchange_rate between", value1, value2, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andExchangeRateNotBetween(Long value1, Long value2) {
            addCriterion("exchange_rate not between", value1, value2, "exchangeRate");
            return (Criteria) this;
        }

        public Criteria andContStateIsNull() {
            addCriterion("cont_state is null");
            return (Criteria) this;
        }

        public Criteria andContStateIsNotNull() {
            addCriterion("cont_state is not null");
            return (Criteria) this;
        }

        public Criteria andContStateEqualTo(Byte value) {
            addCriterion("cont_state =", value, "contState");
            return (Criteria) this;
        }

        public Criteria andContStateNotEqualTo(Byte value) {
            addCriterion("cont_state <>", value, "contState");
            return (Criteria) this;
        }

        public Criteria andContStateGreaterThan(Byte value) {
            addCriterion("cont_state >", value, "contState");
            return (Criteria) this;
        }

        public Criteria andContStateGreaterThanOrEqualTo(Byte value) {
            addCriterion("cont_state >=", value, "contState");
            return (Criteria) this;
        }

        public Criteria andContStateLessThan(Byte value) {
            addCriterion("cont_state <", value, "contState");
            return (Criteria) this;
        }

        public Criteria andContStateLessThanOrEqualTo(Byte value) {
            addCriterion("cont_state <=", value, "contState");
            return (Criteria) this;
        }

        public Criteria andContStateIn(List<Byte> values) {
            addCriterion("cont_state in", values, "contState");
            return (Criteria) this;
        }

        public Criteria andContStateNotIn(List<Byte> values) {
            addCriterion("cont_state not in", values, "contState");
            return (Criteria) this;
        }

        public Criteria andContStateBetween(Byte value1, Byte value2) {
            addCriterion("cont_state between", value1, value2, "contState");
            return (Criteria) this;
        }

        public Criteria andContStateNotBetween(Byte value1, Byte value2) {
            addCriterion("cont_state not between", value1, value2, "contState");
            return (Criteria) this;
        }

        public Criteria andPrintNumIsNull() {
            addCriterion("print_num is null");
            return (Criteria) this;
        }

        public Criteria andPrintNumIsNotNull() {
            addCriterion("print_num is not null");
            return (Criteria) this;
        }

        public Criteria andPrintNumEqualTo(Byte value) {
            addCriterion("print_num =", value, "printNum");
            return (Criteria) this;
        }

        public Criteria andPrintNumNotEqualTo(Byte value) {
            addCriterion("print_num <>", value, "printNum");
            return (Criteria) this;
        }

        public Criteria andPrintNumGreaterThan(Byte value) {
            addCriterion("print_num >", value, "printNum");
            return (Criteria) this;
        }

        public Criteria andPrintNumGreaterThanOrEqualTo(Byte value) {
            addCriterion("print_num >=", value, "printNum");
            return (Criteria) this;
        }

        public Criteria andPrintNumLessThan(Byte value) {
            addCriterion("print_num <", value, "printNum");
            return (Criteria) this;
        }

        public Criteria andPrintNumLessThanOrEqualTo(Byte value) {
            addCriterion("print_num <=", value, "printNum");
            return (Criteria) this;
        }

        public Criteria andPrintNumIn(List<Byte> values) {
            addCriterion("print_num in", values, "printNum");
            return (Criteria) this;
        }

        public Criteria andPrintNumNotIn(List<Byte> values) {
            addCriterion("print_num not in", values, "printNum");
            return (Criteria) this;
        }

        public Criteria andPrintNumBetween(Byte value1, Byte value2) {
            addCriterion("print_num between", value1, value2, "printNum");
            return (Criteria) this;
        }

        public Criteria andPrintNumNotBetween(Byte value1, Byte value2) {
            addCriterion("print_num not between", value1, value2, "printNum");
            return (Criteria) this;
        }

        public Criteria andCUserUidIsNull() {
            addCriterion("c_user_uid is null");
            return (Criteria) this;
        }

        public Criteria andCUserUidIsNotNull() {
            addCriterion("c_user_uid is not null");
            return (Criteria) this;
        }

        public Criteria andCUserUidEqualTo(String value) {
            addCriterion("c_user_uid =", value, "cUserUid");
            return (Criteria) this;
        }

        public Criteria andCUserUidNotEqualTo(String value) {
            addCriterion("c_user_uid <>", value, "cUserUid");
            return (Criteria) this;
        }

        public Criteria andCUserUidGreaterThan(String value) {
            addCriterion("c_user_uid >", value, "cUserUid");
            return (Criteria) this;
        }

        public Criteria andCUserUidGreaterThanOrEqualTo(String value) {
            addCriterion("c_user_uid >=", value, "cUserUid");
            return (Criteria) this;
        }

        public Criteria andCUserUidLessThan(String value) {
            addCriterion("c_user_uid <", value, "cUserUid");
            return (Criteria) this;
        }

        public Criteria andCUserUidLessThanOrEqualTo(String value) {
            addCriterion("c_user_uid <=", value, "cUserUid");
            return (Criteria) this;
        }

        public Criteria andCUserUidLike(String value) {
            addCriterion("c_user_uid like", value, "cUserUid");
            return (Criteria) this;
        }

        public Criteria andCUserUidNotLike(String value) {
            addCriterion("c_user_uid not like", value, "cUserUid");
            return (Criteria) this;
        }

        public Criteria andCUserUidIn(List<String> values) {
            addCriterion("c_user_uid in", values, "cUserUid");
            return (Criteria) this;
        }

        public Criteria andCUserUidNotIn(List<String> values) {
            addCriterion("c_user_uid not in", values, "cUserUid");
            return (Criteria) this;
        }

        public Criteria andCUserUidBetween(String value1, String value2) {
            addCriterion("c_user_uid between", value1, value2, "cUserUid");
            return (Criteria) this;
        }

        public Criteria andCUserUidNotBetween(String value1, String value2) {
            addCriterion("c_user_uid not between", value1, value2, "cUserUid");
            return (Criteria) this;
        }

        public Criteria andCTimeIsNull() {
            addCriterion("C_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCTimeIsNotNull() {
            addCriterion("C_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCTimeEqualTo(Date value) {
            addCriterion("C_TIME =", value, "cTime");
            return (Criteria) this;
        }

        public Criteria andCTimeNotEqualTo(Date value) {
            addCriterion("C_TIME <>", value, "cTime");
            return (Criteria) this;
        }

        public Criteria andCTimeGreaterThan(Date value) {
            addCriterion("C_TIME >", value, "cTime");
            return (Criteria) this;
        }

        public Criteria andCTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("C_TIME >=", value, "cTime");
            return (Criteria) this;
        }

        public Criteria andCTimeLessThan(Date value) {
            addCriterion("C_TIME <", value, "cTime");
            return (Criteria) this;
        }

        public Criteria andCTimeLessThanOrEqualTo(Date value) {
            addCriterion("C_TIME <=", value, "cTime");
            return (Criteria) this;
        }

        public Criteria andCTimeIn(List<Date> values) {
            addCriterion("C_TIME in", values, "cTime");
            return (Criteria) this;
        }

        public Criteria andCTimeNotIn(List<Date> values) {
            addCriterion("C_TIME not in", values, "cTime");
            return (Criteria) this;
        }

        public Criteria andCTimeBetween(Date value1, Date value2) {
            addCriterion("C_TIME between", value1, value2, "cTime");
            return (Criteria) this;
        }

        public Criteria andCTimeNotBetween(Date value1, Date value2) {
            addCriterion("C_TIME not between", value1, value2, "cTime");
            return (Criteria) this;
        }

        public Criteria andMUserUidIsNull() {
            addCriterion("m_user_uid is null");
            return (Criteria) this;
        }

        public Criteria andMUserUidIsNotNull() {
            addCriterion("m_user_uid is not null");
            return (Criteria) this;
        }

        public Criteria andMUserUidEqualTo(String value) {
            addCriterion("m_user_uid =", value, "mUserUid");
            return (Criteria) this;
        }

        public Criteria andMUserUidNotEqualTo(String value) {
            addCriterion("m_user_uid <>", value, "mUserUid");
            return (Criteria) this;
        }

        public Criteria andMUserUidGreaterThan(String value) {
            addCriterion("m_user_uid >", value, "mUserUid");
            return (Criteria) this;
        }

        public Criteria andMUserUidGreaterThanOrEqualTo(String value) {
            addCriterion("m_user_uid >=", value, "mUserUid");
            return (Criteria) this;
        }

        public Criteria andMUserUidLessThan(String value) {
            addCriterion("m_user_uid <", value, "mUserUid");
            return (Criteria) this;
        }

        public Criteria andMUserUidLessThanOrEqualTo(String value) {
            addCriterion("m_user_uid <=", value, "mUserUid");
            return (Criteria) this;
        }

        public Criteria andMUserUidLike(String value) {
            addCriterion("m_user_uid like", value, "mUserUid");
            return (Criteria) this;
        }

        public Criteria andMUserUidNotLike(String value) {
            addCriterion("m_user_uid not like", value, "mUserUid");
            return (Criteria) this;
        }

        public Criteria andMUserUidIn(List<String> values) {
            addCriterion("m_user_uid in", values, "mUserUid");
            return (Criteria) this;
        }

        public Criteria andMUserUidNotIn(List<String> values) {
            addCriterion("m_user_uid not in", values, "mUserUid");
            return (Criteria) this;
        }

        public Criteria andMUserUidBetween(String value1, String value2) {
            addCriterion("m_user_uid between", value1, value2, "mUserUid");
            return (Criteria) this;
        }

        public Criteria andMUserUidNotBetween(String value1, String value2) {
            addCriterion("m_user_uid not between", value1, value2, "mUserUid");
            return (Criteria) this;
        }

        public Criteria andMTimeIsNull() {
            addCriterion("m_time is null");
            return (Criteria) this;
        }

        public Criteria andMTimeIsNotNull() {
            addCriterion("m_time is not null");
            return (Criteria) this;
        }

        public Criteria andMTimeEqualTo(Date value) {
            addCriterion("m_time =", value, "mTime");
            return (Criteria) this;
        }

        public Criteria andMTimeNotEqualTo(Date value) {
            addCriterion("m_time <>", value, "mTime");
            return (Criteria) this;
        }

        public Criteria andMTimeGreaterThan(Date value) {
            addCriterion("m_time >", value, "mTime");
            return (Criteria) this;
        }

        public Criteria andMTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("m_time >=", value, "mTime");
            return (Criteria) this;
        }

        public Criteria andMTimeLessThan(Date value) {
            addCriterion("m_time <", value, "mTime");
            return (Criteria) this;
        }

        public Criteria andMTimeLessThanOrEqualTo(Date value) {
            addCriterion("m_time <=", value, "mTime");
            return (Criteria) this;
        }

        public Criteria andMTimeIn(List<Date> values) {
            addCriterion("m_time in", values, "mTime");
            return (Criteria) this;
        }

        public Criteria andMTimeNotIn(List<Date> values) {
            addCriterion("m_time not in", values, "mTime");
            return (Criteria) this;
        }

        public Criteria andMTimeBetween(Date value1, Date value2) {
            addCriterion("m_time between", value1, value2, "mTime");
            return (Criteria) this;
        }

        public Criteria andMTimeNotBetween(Date value1, Date value2) {
            addCriterion("m_time not between", value1, value2, "mTime");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andCorporationPartAIsNull() {
            addCriterion("corporation_part_a is null");
            return (Criteria) this;
        }

        public Criteria andCorporationPartAIsNotNull() {
            addCriterion("corporation_part_a is not null");
            return (Criteria) this;
        }

        public Criteria andCorporationPartAEqualTo(String value) {
            addCriterion("corporation_part_a =", value, "corporationPartA");
            return (Criteria) this;
        }

        public Criteria andCorporationPartANotEqualTo(String value) {
            addCriterion("corporation_part_a <>", value, "corporationPartA");
            return (Criteria) this;
        }

        public Criteria andCorporationPartAGreaterThan(String value) {
            addCriterion("corporation_part_a >", value, "corporationPartA");
            return (Criteria) this;
        }

        public Criteria andCorporationPartAGreaterThanOrEqualTo(String value) {
            addCriterion("corporation_part_a >=", value, "corporationPartA");
            return (Criteria) this;
        }

        public Criteria andCorporationPartALessThan(String value) {
            addCriterion("corporation_part_a <", value, "corporationPartA");
            return (Criteria) this;
        }

        public Criteria andCorporationPartALessThanOrEqualTo(String value) {
            addCriterion("corporation_part_a <=", value, "corporationPartA");
            return (Criteria) this;
        }

        public Criteria andCorporationPartALike(String value) {
            addCriterion("corporation_part_a like", value, "corporationPartA");
            return (Criteria) this;
        }

        public Criteria andCorporationPartANotLike(String value) {
            addCriterion("corporation_part_a not like", value, "corporationPartA");
            return (Criteria) this;
        }

        public Criteria andCorporationPartAIn(List<String> values) {
            addCriterion("corporation_part_a in", values, "corporationPartA");
            return (Criteria) this;
        }

        public Criteria andCorporationPartANotIn(List<String> values) {
            addCriterion("corporation_part_a not in", values, "corporationPartA");
            return (Criteria) this;
        }

        public Criteria andCorporationPartABetween(String value1, String value2) {
            addCriterion("corporation_part_a between", value1, value2, "corporationPartA");
            return (Criteria) this;
        }

        public Criteria andCorporationPartANotBetween(String value1, String value2) {
            addCriterion("corporation_part_a not between", value1, value2, "corporationPartA");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBIsNull() {
            addCriterion("corporation_part_b is null");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBIsNotNull() {
            addCriterion("corporation_part_b is not null");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBEqualTo(String value) {
            addCriterion("corporation_part_b =", value, "corporationPartB");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBNotEqualTo(String value) {
            addCriterion("corporation_part_b <>", value, "corporationPartB");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBGreaterThan(String value) {
            addCriterion("corporation_part_b >", value, "corporationPartB");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBGreaterThanOrEqualTo(String value) {
            addCriterion("corporation_part_b >=", value, "corporationPartB");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBLessThan(String value) {
            addCriterion("corporation_part_b <", value, "corporationPartB");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBLessThanOrEqualTo(String value) {
            addCriterion("corporation_part_b <=", value, "corporationPartB");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBLike(String value) {
            addCriterion("corporation_part_b like", value, "corporationPartB");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBNotLike(String value) {
            addCriterion("corporation_part_b not like", value, "corporationPartB");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBIn(List<String> values) {
            addCriterion("corporation_part_b in", values, "corporationPartB");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBNotIn(List<String> values) {
            addCriterion("corporation_part_b not in", values, "corporationPartB");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBBetween(String value1, String value2) {
            addCriterion("corporation_part_b between", value1, value2, "corporationPartB");
            return (Criteria) this;
        }

        public Criteria andCorporationPartBNotBetween(String value1, String value2) {
            addCriterion("corporation_part_b not between", value1, value2, "corporationPartB");
            return (Criteria) this;
        }

        public Criteria andPostcodePartAIsNull() {
            addCriterion("postcode_part_a is null");
            return (Criteria) this;
        }

        public Criteria andPostcodePartAIsNotNull() {
            addCriterion("postcode_part_a is not null");
            return (Criteria) this;
        }

        public Criteria andPostcodePartAEqualTo(String value) {
            addCriterion("postcode_part_a =", value, "postcodePartA");
            return (Criteria) this;
        }

        public Criteria andPostcodePartANotEqualTo(String value) {
            addCriterion("postcode_part_a <>", value, "postcodePartA");
            return (Criteria) this;
        }

        public Criteria andPostcodePartAGreaterThan(String value) {
            addCriterion("postcode_part_a >", value, "postcodePartA");
            return (Criteria) this;
        }

        public Criteria andPostcodePartAGreaterThanOrEqualTo(String value) {
            addCriterion("postcode_part_a >=", value, "postcodePartA");
            return (Criteria) this;
        }

        public Criteria andPostcodePartALessThan(String value) {
            addCriterion("postcode_part_a <", value, "postcodePartA");
            return (Criteria) this;
        }

        public Criteria andPostcodePartALessThanOrEqualTo(String value) {
            addCriterion("postcode_part_a <=", value, "postcodePartA");
            return (Criteria) this;
        }

        public Criteria andPostcodePartALike(String value) {
            addCriterion("postcode_part_a like", value, "postcodePartA");
            return (Criteria) this;
        }

        public Criteria andPostcodePartANotLike(String value) {
            addCriterion("postcode_part_a not like", value, "postcodePartA");
            return (Criteria) this;
        }

        public Criteria andPostcodePartAIn(List<String> values) {
            addCriterion("postcode_part_a in", values, "postcodePartA");
            return (Criteria) this;
        }

        public Criteria andPostcodePartANotIn(List<String> values) {
            addCriterion("postcode_part_a not in", values, "postcodePartA");
            return (Criteria) this;
        }

        public Criteria andPostcodePartABetween(String value1, String value2) {
            addCriterion("postcode_part_a between", value1, value2, "postcodePartA");
            return (Criteria) this;
        }

        public Criteria andPostcodePartANotBetween(String value1, String value2) {
            addCriterion("postcode_part_a not between", value1, value2, "postcodePartA");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBIsNull() {
            addCriterion("postcode_part_b is null");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBIsNotNull() {
            addCriterion("postcode_part_b is not null");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBEqualTo(String value) {
            addCriterion("postcode_part_b =", value, "postcodePartB");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBNotEqualTo(String value) {
            addCriterion("postcode_part_b <>", value, "postcodePartB");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBGreaterThan(String value) {
            addCriterion("postcode_part_b >", value, "postcodePartB");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBGreaterThanOrEqualTo(String value) {
            addCriterion("postcode_part_b >=", value, "postcodePartB");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBLessThan(String value) {
            addCriterion("postcode_part_b <", value, "postcodePartB");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBLessThanOrEqualTo(String value) {
            addCriterion("postcode_part_b <=", value, "postcodePartB");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBLike(String value) {
            addCriterion("postcode_part_b like", value, "postcodePartB");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBNotLike(String value) {
            addCriterion("postcode_part_b not like", value, "postcodePartB");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBIn(List<String> values) {
            addCriterion("postcode_part_b in", values, "postcodePartB");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBNotIn(List<String> values) {
            addCriterion("postcode_part_b not in", values, "postcodePartB");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBBetween(String value1, String value2) {
            addCriterion("postcode_part_b between", value1, value2, "postcodePartB");
            return (Criteria) this;
        }

        public Criteria andPostcodePartBNotBetween(String value1, String value2) {
            addCriterion("postcode_part_b not between", value1, value2, "postcodePartB");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNull() {
            addCriterion("start_time is null");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNotNull() {
            addCriterion("start_time is not null");
            return (Criteria) this;
        }

        public Criteria andStartTimeEqualTo(Date value) {
            addCriterion("start_time =", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotEqualTo(Date value) {
            addCriterion("start_time <>", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThan(Date value) {
            addCriterion("start_time >", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("start_time >=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThan(Date value) {
            addCriterion("start_time <", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("start_time <=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIn(List<Date> values) {
            addCriterion("start_time in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotIn(List<Date> values) {
            addCriterion("start_time not in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeBetween(Date value1, Date value2) {
            addCriterion("start_time between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("start_time not between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("end_time is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("end_time is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("end_time =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("end_time <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("end_time >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("end_time >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("end_time <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("end_time <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("end_time in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("end_time not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("end_time between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("end_time not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andYearIsNull() {
            addCriterion("`year` is null");
            return (Criteria) this;
        }

        public Criteria andYearIsNotNull() {
            addCriterion("`year` is not null");
            return (Criteria) this;
        }

        public Criteria andYearEqualTo(Long value) {
            addCriterion("`year` =", value, "year");
            return (Criteria) this;
        }

        public Criteria andYearNotEqualTo(Long value) {
            addCriterion("`year` <>", value, "year");
            return (Criteria) this;
        }

        public Criteria andYearGreaterThan(Long value) {
            addCriterion("`year` >", value, "year");
            return (Criteria) this;
        }

        public Criteria andYearGreaterThanOrEqualTo(Long value) {
            addCriterion("`year` >=", value, "year");
            return (Criteria) this;
        }

        public Criteria andYearLessThan(Long value) {
            addCriterion("`year` <", value, "year");
            return (Criteria) this;
        }

        public Criteria andYearLessThanOrEqualTo(Long value) {
            addCriterion("`year` <=", value, "year");
            return (Criteria) this;
        }

        public Criteria andYearIn(List<Long> values) {
            addCriterion("`year` in", values, "year");
            return (Criteria) this;
        }

        public Criteria andYearNotIn(List<Long> values) {
            addCriterion("`year` not in", values, "year");
            return (Criteria) this;
        }

        public Criteria andYearBetween(Long value1, Long value2) {
            addCriterion("`year` between", value1, value2, "year");
            return (Criteria) this;
        }

        public Criteria andYearNotBetween(Long value1, Long value2) {
            addCriterion("`year` not between", value1, value2, "year");
            return (Criteria) this;
        }

        public Criteria andLateFeesIsNull() {
            addCriterion("late_fees is null");
            return (Criteria) this;
        }

        public Criteria andLateFeesIsNotNull() {
            addCriterion("late_fees is not null");
            return (Criteria) this;
        }

        public Criteria andLateFeesEqualTo(Long value) {
            addCriterion("late_fees =", value, "lateFees");
            return (Criteria) this;
        }

        public Criteria andLateFeesNotEqualTo(Long value) {
            addCriterion("late_fees <>", value, "lateFees");
            return (Criteria) this;
        }

        public Criteria andLateFeesGreaterThan(Long value) {
            addCriterion("late_fees >", value, "lateFees");
            return (Criteria) this;
        }

        public Criteria andLateFeesGreaterThanOrEqualTo(Long value) {
            addCriterion("late_fees >=", value, "lateFees");
            return (Criteria) this;
        }

        public Criteria andLateFeesLessThan(Long value) {
            addCriterion("late_fees <", value, "lateFees");
            return (Criteria) this;
        }

        public Criteria andLateFeesLessThanOrEqualTo(Long value) {
            addCriterion("late_fees <=", value, "lateFees");
            return (Criteria) this;
        }

        public Criteria andLateFeesIn(List<Long> values) {
            addCriterion("late_fees in", values, "lateFees");
            return (Criteria) this;
        }

        public Criteria andLateFeesNotIn(List<Long> values) {
            addCriterion("late_fees not in", values, "lateFees");
            return (Criteria) this;
        }

        public Criteria andLateFeesBetween(Long value1, Long value2) {
            addCriterion("late_fees between", value1, value2, "lateFees");
            return (Criteria) this;
        }

        public Criteria andLateFeesNotBetween(Long value1, Long value2) {
            addCriterion("late_fees not between", value1, value2, "lateFees");
            return (Criteria) this;
        }

        public Criteria andMissIsNull() {
            addCriterion("miss is null");
            return (Criteria) this;
        }

        public Criteria andMissIsNotNull() {
            addCriterion("miss is not null");
            return (Criteria) this;
        }

        public Criteria andMissEqualTo(Long value) {
            addCriterion("miss =", value, "miss");
            return (Criteria) this;
        }

        public Criteria andMissNotEqualTo(Long value) {
            addCriterion("miss <>", value, "miss");
            return (Criteria) this;
        }

        public Criteria andMissGreaterThan(Long value) {
            addCriterion("miss >", value, "miss");
            return (Criteria) this;
        }

        public Criteria andMissGreaterThanOrEqualTo(Long value) {
            addCriterion("miss >=", value, "miss");
            return (Criteria) this;
        }

        public Criteria andMissLessThan(Long value) {
            addCriterion("miss <", value, "miss");
            return (Criteria) this;
        }

        public Criteria andMissLessThanOrEqualTo(Long value) {
            addCriterion("miss <=", value, "miss");
            return (Criteria) this;
        }

        public Criteria andMissIn(List<Long> values) {
            addCriterion("miss in", values, "miss");
            return (Criteria) this;
        }

        public Criteria andMissNotIn(List<Long> values) {
            addCriterion("miss not in", values, "miss");
            return (Criteria) this;
        }

        public Criteria andMissBetween(Long value1, Long value2) {
            addCriterion("miss between", value1, value2, "miss");
            return (Criteria) this;
        }

        public Criteria andMissNotBetween(Long value1, Long value2) {
            addCriterion("miss not between", value1, value2, "miss");
            return (Criteria) this;
        }

        public Criteria andDoaIsNull() {
            addCriterion("doa is null");
            return (Criteria) this;
        }

        public Criteria andDoaIsNotNull() {
            addCriterion("doa is not null");
            return (Criteria) this;
        }

        public Criteria andDoaEqualTo(Long value) {
            addCriterion("doa =", value, "doa");
            return (Criteria) this;
        }

        public Criteria andDoaNotEqualTo(Long value) {
            addCriterion("doa <>", value, "doa");
            return (Criteria) this;
        }

        public Criteria andDoaGreaterThan(Long value) {
            addCriterion("doa >", value, "doa");
            return (Criteria) this;
        }

        public Criteria andDoaGreaterThanOrEqualTo(Long value) {
            addCriterion("doa >=", value, "doa");
            return (Criteria) this;
        }

        public Criteria andDoaLessThan(Long value) {
            addCriterion("doa <", value, "doa");
            return (Criteria) this;
        }

        public Criteria andDoaLessThanOrEqualTo(Long value) {
            addCriterion("doa <=", value, "doa");
            return (Criteria) this;
        }

        public Criteria andDoaIn(List<Long> values) {
            addCriterion("doa in", values, "doa");
            return (Criteria) this;
        }

        public Criteria andDoaNotIn(List<Long> values) {
            addCriterion("doa not in", values, "doa");
            return (Criteria) this;
        }

        public Criteria andDoaBetween(Long value1, Long value2) {
            addCriterion("doa between", value1, value2, "doa");
            return (Criteria) this;
        }

        public Criteria andDoaNotBetween(Long value1, Long value2) {
            addCriterion("doa not between", value1, value2, "doa");
            return (Criteria) this;
        }

        public Criteria andMissFineIsNull() {
            addCriterion("miss_fine is null");
            return (Criteria) this;
        }

        public Criteria andMissFineIsNotNull() {
            addCriterion("miss_fine is not null");
            return (Criteria) this;
        }

        public Criteria andMissFineEqualTo(Long value) {
            addCriterion("miss_fine =", value, "missFine");
            return (Criteria) this;
        }

        public Criteria andMissFineNotEqualTo(Long value) {
            addCriterion("miss_fine <>", value, "missFine");
            return (Criteria) this;
        }

        public Criteria andMissFineGreaterThan(Long value) {
            addCriterion("miss_fine >", value, "missFine");
            return (Criteria) this;
        }

        public Criteria andMissFineGreaterThanOrEqualTo(Long value) {
            addCriterion("miss_fine >=", value, "missFine");
            return (Criteria) this;
        }

        public Criteria andMissFineLessThan(Long value) {
            addCriterion("miss_fine <", value, "missFine");
            return (Criteria) this;
        }

        public Criteria andMissFineLessThanOrEqualTo(Long value) {
            addCriterion("miss_fine <=", value, "missFine");
            return (Criteria) this;
        }

        public Criteria andMissFineIn(List<Long> values) {
            addCriterion("miss_fine in", values, "missFine");
            return (Criteria) this;
        }

        public Criteria andMissFineNotIn(List<Long> values) {
            addCriterion("miss_fine not in", values, "missFine");
            return (Criteria) this;
        }

        public Criteria andMissFineBetween(Long value1, Long value2) {
            addCriterion("miss_fine between", value1, value2, "missFine");
            return (Criteria) this;
        }

        public Criteria andMissFineNotBetween(Long value1, Long value2) {
            addCriterion("miss_fine not between", value1, value2, "missFine");
            return (Criteria) this;
        }

        public Criteria andDoaFineIsNull() {
            addCriterion("doa_fine is null");
            return (Criteria) this;
        }

        public Criteria andDoaFineIsNotNull() {
            addCriterion("doa_fine is not null");
            return (Criteria) this;
        }

        public Criteria andDoaFineEqualTo(Long value) {
            addCriterion("doa_fine =", value, "doaFine");
            return (Criteria) this;
        }

        public Criteria andDoaFineNotEqualTo(Long value) {
            addCriterion("doa_fine <>", value, "doaFine");
            return (Criteria) this;
        }

        public Criteria andDoaFineGreaterThan(Long value) {
            addCriterion("doa_fine >", value, "doaFine");
            return (Criteria) this;
        }

        public Criteria andDoaFineGreaterThanOrEqualTo(Long value) {
            addCriterion("doa_fine >=", value, "doaFine");
            return (Criteria) this;
        }

        public Criteria andDoaFineLessThan(Long value) {
            addCriterion("doa_fine <", value, "doaFine");
            return (Criteria) this;
        }

        public Criteria andDoaFineLessThanOrEqualTo(Long value) {
            addCriterion("doa_fine <=", value, "doaFine");
            return (Criteria) this;
        }

        public Criteria andDoaFineIn(List<Long> values) {
            addCriterion("doa_fine in", values, "doaFine");
            return (Criteria) this;
        }

        public Criteria andDoaFineNotIn(List<Long> values) {
            addCriterion("doa_fine not in", values, "doaFine");
            return (Criteria) this;
        }

        public Criteria andDoaFineBetween(Long value1, Long value2) {
            addCriterion("doa_fine between", value1, value2, "doaFine");
            return (Criteria) this;
        }

        public Criteria andDoaFineNotBetween(Long value1, Long value2) {
            addCriterion("doa_fine not between", value1, value2, "doaFine");
            return (Criteria) this;
        }

        public Criteria andDepositIsNull() {
            addCriterion("deposit is null");
            return (Criteria) this;
        }

        public Criteria andDepositIsNotNull() {
            addCriterion("deposit is not null");
            return (Criteria) this;
        }

        public Criteria andDepositEqualTo(Long value) {
            addCriterion("deposit =", value, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositNotEqualTo(Long value) {
            addCriterion("deposit <>", value, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositGreaterThan(Long value) {
            addCriterion("deposit >", value, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositGreaterThanOrEqualTo(Long value) {
            addCriterion("deposit >=", value, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositLessThan(Long value) {
            addCriterion("deposit <", value, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositLessThanOrEqualTo(Long value) {
            addCriterion("deposit <=", value, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositIn(List<Long> values) {
            addCriterion("deposit in", values, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositNotIn(List<Long> values) {
            addCriterion("deposit not in", values, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositBetween(Long value1, Long value2) {
            addCriterion("deposit between", value1, value2, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositNotBetween(Long value1, Long value2) {
            addCriterion("deposit not between", value1, value2, "deposit");
            return (Criteria) this;
        }

        public Criteria andMediatorIsNull() {
            addCriterion("mediator is null");
            return (Criteria) this;
        }

        public Criteria andMediatorIsNotNull() {
            addCriterion("mediator is not null");
            return (Criteria) this;
        }

        public Criteria andMediatorEqualTo(String value) {
            addCriterion("mediator =", value, "mediator");
            return (Criteria) this;
        }

        public Criteria andMediatorNotEqualTo(String value) {
            addCriterion("mediator <>", value, "mediator");
            return (Criteria) this;
        }

        public Criteria andMediatorGreaterThan(String value) {
            addCriterion("mediator >", value, "mediator");
            return (Criteria) this;
        }

        public Criteria andMediatorGreaterThanOrEqualTo(String value) {
            addCriterion("mediator >=", value, "mediator");
            return (Criteria) this;
        }

        public Criteria andMediatorLessThan(String value) {
            addCriterion("mediator <", value, "mediator");
            return (Criteria) this;
        }

        public Criteria andMediatorLessThanOrEqualTo(String value) {
            addCriterion("mediator <=", value, "mediator");
            return (Criteria) this;
        }

        public Criteria andMediatorLike(String value) {
            addCriterion("mediator like", value, "mediator");
            return (Criteria) this;
        }

        public Criteria andMediatorNotLike(String value) {
            addCriterion("mediator not like", value, "mediator");
            return (Criteria) this;
        }

        public Criteria andMediatorIn(List<String> values) {
            addCriterion("mediator in", values, "mediator");
            return (Criteria) this;
        }

        public Criteria andMediatorNotIn(List<String> values) {
            addCriterion("mediator not in", values, "mediator");
            return (Criteria) this;
        }

        public Criteria andMediatorBetween(String value1, String value2) {
            addCriterion("mediator between", value1, value2, "mediator");
            return (Criteria) this;
        }

        public Criteria andMediatorNotBetween(String value1, String value2) {
            addCriterion("mediator not between", value1, value2, "mediator");
            return (Criteria) this;
        }

        public Criteria andDeliveryDayIsNull() {
            addCriterion("delivery_day is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDayIsNotNull() {
            addCriterion("delivery_day is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDayEqualTo(Long value) {
            addCriterion("delivery_day =", value, "deliveryDay");
            return (Criteria) this;
        }

        public Criteria andDeliveryDayNotEqualTo(Long value) {
            addCriterion("delivery_day <>", value, "deliveryDay");
            return (Criteria) this;
        }

        public Criteria andDeliveryDayGreaterThan(Long value) {
            addCriterion("delivery_day >", value, "deliveryDay");
            return (Criteria) this;
        }

        public Criteria andDeliveryDayGreaterThanOrEqualTo(Long value) {
            addCriterion("delivery_day >=", value, "deliveryDay");
            return (Criteria) this;
        }

        public Criteria andDeliveryDayLessThan(Long value) {
            addCriterion("delivery_day <", value, "deliveryDay");
            return (Criteria) this;
        }

        public Criteria andDeliveryDayLessThanOrEqualTo(Long value) {
            addCriterion("delivery_day <=", value, "deliveryDay");
            return (Criteria) this;
        }

        public Criteria andDeliveryDayIn(List<Long> values) {
            addCriterion("delivery_day in", values, "deliveryDay");
            return (Criteria) this;
        }

        public Criteria andDeliveryDayNotIn(List<Long> values) {
            addCriterion("delivery_day not in", values, "deliveryDay");
            return (Criteria) this;
        }

        public Criteria andDeliveryDayBetween(Long value1, Long value2) {
            addCriterion("delivery_day between", value1, value2, "deliveryDay");
            return (Criteria) this;
        }

        public Criteria andDeliveryDayNotBetween(Long value1, Long value2) {
            addCriterion("delivery_day not between", value1, value2, "deliveryDay");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeIsNull() {
            addCriterion("delivery_type is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeIsNotNull() {
            addCriterion("delivery_type is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeEqualTo(String value) {
            addCriterion("delivery_type =", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeNotEqualTo(String value) {
            addCriterion("delivery_type <>", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeGreaterThan(String value) {
            addCriterion("delivery_type >", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeGreaterThanOrEqualTo(String value) {
            addCriterion("delivery_type >=", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeLessThan(String value) {
            addCriterion("delivery_type <", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeLessThanOrEqualTo(String value) {
            addCriterion("delivery_type <=", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeLike(String value) {
            addCriterion("delivery_type like", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeNotLike(String value) {
            addCriterion("delivery_type not like", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeIn(List<String> values) {
            addCriterion("delivery_type in", values, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeNotIn(List<String> values) {
            addCriterion("delivery_type not in", values, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeBetween(String value1, String value2) {
            addCriterion("delivery_type between", value1, value2, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeNotBetween(String value1, String value2) {
            addCriterion("delivery_type not between", value1, value2, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andTransportTypeIsNull() {
            addCriterion("transport_type is null");
            return (Criteria) this;
        }

        public Criteria andTransportTypeIsNotNull() {
            addCriterion("transport_type is not null");
            return (Criteria) this;
        }

        public Criteria andTransportTypeEqualTo(String value) {
            addCriterion("transport_type =", value, "transportType");
            return (Criteria) this;
        }

        public Criteria andTransportTypeNotEqualTo(String value) {
            addCriterion("transport_type <>", value, "transportType");
            return (Criteria) this;
        }

        public Criteria andTransportTypeGreaterThan(String value) {
            addCriterion("transport_type >", value, "transportType");
            return (Criteria) this;
        }

        public Criteria andTransportTypeGreaterThanOrEqualTo(String value) {
            addCriterion("transport_type >=", value, "transportType");
            return (Criteria) this;
        }

        public Criteria andTransportTypeLessThan(String value) {
            addCriterion("transport_type <", value, "transportType");
            return (Criteria) this;
        }

        public Criteria andTransportTypeLessThanOrEqualTo(String value) {
            addCriterion("transport_type <=", value, "transportType");
            return (Criteria) this;
        }

        public Criteria andTransportTypeLike(String value) {
            addCriterion("transport_type like", value, "transportType");
            return (Criteria) this;
        }

        public Criteria andTransportTypeNotLike(String value) {
            addCriterion("transport_type not like", value, "transportType");
            return (Criteria) this;
        }

        public Criteria andTransportTypeIn(List<String> values) {
            addCriterion("transport_type in", values, "transportType");
            return (Criteria) this;
        }

        public Criteria andTransportTypeNotIn(List<String> values) {
            addCriterion("transport_type not in", values, "transportType");
            return (Criteria) this;
        }

        public Criteria andTransportTypeBetween(String value1, String value2) {
            addCriterion("transport_type between", value1, value2, "transportType");
            return (Criteria) this;
        }

        public Criteria andTransportTypeNotBetween(String value1, String value2) {
            addCriterion("transport_type not between", value1, value2, "transportType");
            return (Criteria) this;
        }

        public Criteria andFreightBearIsNull() {
            addCriterion("freight_bear is null");
            return (Criteria) this;
        }

        public Criteria andFreightBearIsNotNull() {
            addCriterion("freight_bear is not null");
            return (Criteria) this;
        }

        public Criteria andFreightBearEqualTo(String value) {
            addCriterion("freight_bear =", value, "freightBear");
            return (Criteria) this;
        }

        public Criteria andFreightBearNotEqualTo(String value) {
            addCriterion("freight_bear <>", value, "freightBear");
            return (Criteria) this;
        }

        public Criteria andFreightBearGreaterThan(String value) {
            addCriterion("freight_bear >", value, "freightBear");
            return (Criteria) this;
        }

        public Criteria andFreightBearGreaterThanOrEqualTo(String value) {
            addCriterion("freight_bear >=", value, "freightBear");
            return (Criteria) this;
        }

        public Criteria andFreightBearLessThan(String value) {
            addCriterion("freight_bear <", value, "freightBear");
            return (Criteria) this;
        }

        public Criteria andFreightBearLessThanOrEqualTo(String value) {
            addCriterion("freight_bear <=", value, "freightBear");
            return (Criteria) this;
        }

        public Criteria andFreightBearLike(String value) {
            addCriterion("freight_bear like", value, "freightBear");
            return (Criteria) this;
        }

        public Criteria andFreightBearNotLike(String value) {
            addCriterion("freight_bear not like", value, "freightBear");
            return (Criteria) this;
        }

        public Criteria andFreightBearIn(List<String> values) {
            addCriterion("freight_bear in", values, "freightBear");
            return (Criteria) this;
        }

        public Criteria andFreightBearNotIn(List<String> values) {
            addCriterion("freight_bear not in", values, "freightBear");
            return (Criteria) this;
        }

        public Criteria andFreightBearBetween(String value1, String value2) {
            addCriterion("freight_bear between", value1, value2, "freightBear");
            return (Criteria) this;
        }

        public Criteria andFreightBearNotBetween(String value1, String value2) {
            addCriterion("freight_bear not between", value1, value2, "freightBear");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressIsNull() {
            addCriterion("delivery_address is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressIsNotNull() {
            addCriterion("delivery_address is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressEqualTo(String value) {
            addCriterion("delivery_address =", value, "deliveryAddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressNotEqualTo(String value) {
            addCriterion("delivery_address <>", value, "deliveryAddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressGreaterThan(String value) {
            addCriterion("delivery_address >", value, "deliveryAddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressGreaterThanOrEqualTo(String value) {
            addCriterion("delivery_address >=", value, "deliveryAddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressLessThan(String value) {
            addCriterion("delivery_address <", value, "deliveryAddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressLessThanOrEqualTo(String value) {
            addCriterion("delivery_address <=", value, "deliveryAddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressLike(String value) {
            addCriterion("delivery_address like", value, "deliveryAddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressNotLike(String value) {
            addCriterion("delivery_address not like", value, "deliveryAddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressIn(List<String> values) {
            addCriterion("delivery_address in", values, "deliveryAddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressNotIn(List<String> values) {
            addCriterion("delivery_address not in", values, "deliveryAddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressBetween(String value1, String value2) {
            addCriterion("delivery_address between", value1, value2, "deliveryAddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryAddressNotBetween(String value1, String value2) {
            addCriterion("delivery_address not between", value1, value2, "deliveryAddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameIsNull() {
            addCriterion("delivery_company_name is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameIsNotNull() {
            addCriterion("delivery_company_name is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameEqualTo(String value) {
            addCriterion("delivery_company_name =", value, "deliveryCompanyName");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameNotEqualTo(String value) {
            addCriterion("delivery_company_name <>", value, "deliveryCompanyName");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameGreaterThan(String value) {
            addCriterion("delivery_company_name >", value, "deliveryCompanyName");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("delivery_company_name >=", value, "deliveryCompanyName");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameLessThan(String value) {
            addCriterion("delivery_company_name <", value, "deliveryCompanyName");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("delivery_company_name <=", value, "deliveryCompanyName");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameLike(String value) {
            addCriterion("delivery_company_name like", value, "deliveryCompanyName");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameNotLike(String value) {
            addCriterion("delivery_company_name not like", value, "deliveryCompanyName");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameIn(List<String> values) {
            addCriterion("delivery_company_name in", values, "deliveryCompanyName");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameNotIn(List<String> values) {
            addCriterion("delivery_company_name not in", values, "deliveryCompanyName");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameBetween(String value1, String value2) {
            addCriterion("delivery_company_name between", value1, value2, "deliveryCompanyName");
            return (Criteria) this;
        }

        public Criteria andDeliveryCompanyNameNotBetween(String value1, String value2) {
            addCriterion("delivery_company_name not between", value1, value2, "deliveryCompanyName");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameIsNull() {
            addCriterion("delivery_name is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameIsNotNull() {
            addCriterion("delivery_name is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameEqualTo(String value) {
            addCriterion("delivery_name =", value, "deliveryName");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameNotEqualTo(String value) {
            addCriterion("delivery_name <>", value, "deliveryName");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameGreaterThan(String value) {
            addCriterion("delivery_name >", value, "deliveryName");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameGreaterThanOrEqualTo(String value) {
            addCriterion("delivery_name >=", value, "deliveryName");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameLessThan(String value) {
            addCriterion("delivery_name <", value, "deliveryName");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameLessThanOrEqualTo(String value) {
            addCriterion("delivery_name <=", value, "deliveryName");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameLike(String value) {
            addCriterion("delivery_name like", value, "deliveryName");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameNotLike(String value) {
            addCriterion("delivery_name not like", value, "deliveryName");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameIn(List<String> values) {
            addCriterion("delivery_name in", values, "deliveryName");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameNotIn(List<String> values) {
            addCriterion("delivery_name not in", values, "deliveryName");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameBetween(String value1, String value2) {
            addCriterion("delivery_name between", value1, value2, "deliveryName");
            return (Criteria) this;
        }

        public Criteria andDeliveryNameNotBetween(String value1, String value2) {
            addCriterion("delivery_name not between", value1, value2, "deliveryName");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneIsNull() {
            addCriterion("delivery_phone is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneIsNotNull() {
            addCriterion("delivery_phone is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneEqualTo(String value) {
            addCriterion("delivery_phone =", value, "deliveryPhone");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneNotEqualTo(String value) {
            addCriterion("delivery_phone <>", value, "deliveryPhone");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneGreaterThan(String value) {
            addCriterion("delivery_phone >", value, "deliveryPhone");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("delivery_phone >=", value, "deliveryPhone");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneLessThan(String value) {
            addCriterion("delivery_phone <", value, "deliveryPhone");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneLessThanOrEqualTo(String value) {
            addCriterion("delivery_phone <=", value, "deliveryPhone");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneLike(String value) {
            addCriterion("delivery_phone like", value, "deliveryPhone");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneNotLike(String value) {
            addCriterion("delivery_phone not like", value, "deliveryPhone");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneIn(List<String> values) {
            addCriterion("delivery_phone in", values, "deliveryPhone");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneNotIn(List<String> values) {
            addCriterion("delivery_phone not in", values, "deliveryPhone");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneBetween(String value1, String value2) {
            addCriterion("delivery_phone between", value1, value2, "deliveryPhone");
            return (Criteria) this;
        }

        public Criteria andDeliveryPhoneNotBetween(String value1, String value2) {
            addCriterion("delivery_phone not between", value1, value2, "deliveryPhone");
            return (Criteria) this;
        }

        public Criteria andFormalContractIsNull() {
            addCriterion("formal_contract is null");
            return (Criteria) this;
        }

        public Criteria andFormalContractIsNotNull() {
            addCriterion("formal_contract is not null");
            return (Criteria) this;
        }

        public Criteria andFormalContractEqualTo(String value) {
            addCriterion("formal_contract =", value, "formalContract");
            return (Criteria) this;
        }

        public Criteria andFormalContractNotEqualTo(String value) {
            addCriterion("formal_contract <>", value, "formalContract");
            return (Criteria) this;
        }

        public Criteria andFormalContractGreaterThan(String value) {
            addCriterion("formal_contract >", value, "formalContract");
            return (Criteria) this;
        }

        public Criteria andFormalContractGreaterThanOrEqualTo(String value) {
            addCriterion("formal_contract >=", value, "formalContract");
            return (Criteria) this;
        }

        public Criteria andFormalContractLessThan(String value) {
            addCriterion("formal_contract <", value, "formalContract");
            return (Criteria) this;
        }

        public Criteria andFormalContractLessThanOrEqualTo(String value) {
            addCriterion("formal_contract <=", value, "formalContract");
            return (Criteria) this;
        }

        public Criteria andFormalContractLike(String value) {
            addCriterion("formal_contract like", value, "formalContract");
            return (Criteria) this;
        }

        public Criteria andFormalContractNotLike(String value) {
            addCriterion("formal_contract not like", value, "formalContract");
            return (Criteria) this;
        }

        public Criteria andFormalContractIn(List<String> values) {
            addCriterion("formal_contract in", values, "formalContract");
            return (Criteria) this;
        }

        public Criteria andFormalContractNotIn(List<String> values) {
            addCriterion("formal_contract not in", values, "formalContract");
            return (Criteria) this;
        }

        public Criteria andFormalContractBetween(String value1, String value2) {
            addCriterion("formal_contract between", value1, value2, "formalContract");
            return (Criteria) this;
        }

        public Criteria andFormalContractNotBetween(String value1, String value2) {
            addCriterion("formal_contract not between", value1, value2, "formalContract");
            return (Criteria) this;
        }

        public Criteria andVipIsNull() {
            addCriterion("vip is null");
            return (Criteria) this;
        }

        public Criteria andVipIsNotNull() {
            addCriterion("vip is not null");
            return (Criteria) this;
        }

        public Criteria andVipEqualTo(String value) {
            addCriterion("vip =", value, "vip");
            return (Criteria) this;
        }

        public Criteria andVipNotEqualTo(String value) {
            addCriterion("vip <>", value, "vip");
            return (Criteria) this;
        }

        public Criteria andVipGreaterThan(String value) {
            addCriterion("vip >", value, "vip");
            return (Criteria) this;
        }

        public Criteria andVipGreaterThanOrEqualTo(String value) {
            addCriterion("vip >=", value, "vip");
            return (Criteria) this;
        }

        public Criteria andVipLessThan(String value) {
            addCriterion("vip <", value, "vip");
            return (Criteria) this;
        }

        public Criteria andVipLessThanOrEqualTo(String value) {
            addCriterion("vip <=", value, "vip");
            return (Criteria) this;
        }

        public Criteria andVipLike(String value) {
            addCriterion("vip like", value, "vip");
            return (Criteria) this;
        }

        public Criteria andVipNotLike(String value) {
            addCriterion("vip not like", value, "vip");
            return (Criteria) this;
        }

        public Criteria andVipIn(List<String> values) {
            addCriterion("vip in", values, "vip");
            return (Criteria) this;
        }

        public Criteria andVipNotIn(List<String> values) {
            addCriterion("vip not in", values, "vip");
            return (Criteria) this;
        }

        public Criteria andVipBetween(String value1, String value2) {
            addCriterion("vip between", value1, value2, "vip");
            return (Criteria) this;
        }

        public Criteria andVipNotBetween(String value1, String value2) {
            addCriterion("vip not between", value1, value2, "vip");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}